Date incorrect

Help Activities
, , ,
1

Hi, please help i’m getting this when trying to convert date Not sure it has an error now but before it was not

image
image770×138 10.1 KB

activity:

image
image831×156 4.77 KB

I also tried using cdate(var) one but same error:
image
image287×338 3.58 KB

I want to change that date format ()

2

Hi @Anelisa_Bolosha1

That means string value tha you are trying to convert is not coming in the correct date time format for conversion.

Please run your workflow in debug mode and then it will throw error during the conversion where it is found invalid. Then check from the locals panel what is the string value that is going in assign statement for conversion. Is it the right format “yyyy/MM/dd” or not.

This will help you identify the problematic string value.

1 Like
3

@Anelisa_Bolosha1

  1. Either the string variable is coming empty or not in the given format
  2. Print usingn log message before this to check the value
  3. Mostly from excel hh:mm:ss also gets added

Cheers

4

set a breakpoint after you got the value from excel. Type in the “immediate form”:
ReceiptDate.gettype. Post the type please.
You may change the way how you read the excel (properties, use excel file), thats a common stumbling block

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.