Date Format

Question

Hello everyone,

I want to change the date format I had from 2021-01-05 to 01/05/2021 (MM/DD/YYYY)

I've tried to do:

DateTimeFormat(DateTimeParse([StartDate],"%Y%m%d"),"%m/%d/%Y")

but it didn't work with me.

Any suggestions?

Thank you in advance!

ShankerV · Accepted Answer

Hi @MonaAlmutairi

Please find the expected result.

DateTimeFormat([Field1],"%m/%d/%Y")

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @MonaAlmutairi

You might have tried to store the output in the same column.

The same column will be in Date Datatype, but the date which you are saving is not in Date format.

Hence the result is stored in the new column with datatype string.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @MonaAlmutairi

Solution 2: If you need the output to be stored in the same column.

Try with multi field formula.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V