Date format

[fieldew1]

Hi,

If this has been posted sincere apiologies. I have date format 02/07/2025 12:11 and trying to convert to 2025-07-02 12:11 using DateTime Parse tool 

but the result is NULL. So Im not sure what I'm doing incorrectly.

Any help is much appreciated.

[fieldew1]

Hi,

If this has been posted sincere apiologies. I have date format 02/07/2025 12:11 and trying to convert to 2025-07-02 12:11 using DateTime Parse tool 

but the result is NULL. So Im not sure what I'm doing incorrectly.

Any help is much appreciated.

[abacon]

@fieldew1 What is the datatype of the date being fed into your convert date tool? Check out the screenshot below as well, does this work for you?

Dates can be tricky due to the data types so make sure that is nailed down.

Bacon

[fieldew1]

Thanks for this

Unfortunately, this doesn't work. The datatype is V_String. Its basically 2nd July 2025 in a different format.

[abacon · Accepted solution]

@fieldew1 I see the confusion, try this formula in your date time tool - dd/MM/yyyy hh:mm. Capitalize the month section, that's the difference between our formulas.

Bacon

[fieldew1]

It has worked! thank you for your help