Skip to main content
Question

Date Error

  • March 11, 2024
  • 2 replies
  • 92 views
P
Forum|alt.badge.img+1

An exception occurred while parsing the date time.

I have a excel column invoice date looping as for each row when trying to convert date as dd-MM-yyyy in loop...getting the above error..”An exception occurred while parsing the date time.”

2 replies

Ganesh Bhat
Most Valuable Pathfinder
Forum|alt.badge.img+19
  • Ganesh BhatMost Valuable Pathfinder
  • Most Valuable Pathfinder
  • March 11, 2024

Hi ,

If you have the Date Time value in string format and while using DateTime: Assign to convert the string into a datetime value, Use the Custom Formats as M/d/y h:m:s a , It will give you the datetime D1 in correct format. 


Then you can use DateTime: To String 

You can reach me through WhatsApp : https://wa.me/message/5B3COVB4TXWHO1 LinkedIn: https://www.linkedin.com/in/ganeshdhogale/ https://www.linkedin.com/company/ai-brahmaai/ YouTube: https://www.youtube.com/@aibrahma1150
Ganesh Bhat
Most Valuable Pathfinder
Forum|alt.badge.img+19
  • Ganesh BhatMost Valuable Pathfinder
  • Most Valuable Pathfinder
  • March 12, 2024

@Prade1645, has the issue been resolved? If not, please let us know, and I will try to help you.

You can reach me through WhatsApp : https://wa.me/message/5B3COVB4TXWHO1 LinkedIn: https://www.linkedin.com/in/ganeshdhogale/ https://www.linkedin.com/company/ai-brahmaai/ YouTube: https://www.youtube.com/@aibrahma1150
Terms & ConditionsCookie settingsAccessibility statement