Unable to change date format

[Kartik21]

I am unable to change the date format from 03/15/2024 (V_WString type) to 2024-03-15. I am using the formula as DateTimeFormat([Transaction Date1], "%d/%m/%Y"). The output column is coming as Null.

I even tried to use the date time tool, but it is not giving all the values in the required format. It is missing some values in between.
Also, I tried to change the filed type to Date but it is also not helpful.

Please suggest solutions for this.

[Kartik21]

I am unable to change the date format from 03/15/2024 (V_WString type) to 2024-03-15. I am using the formula as DateTimeFormat([Transaction Date1], "%d/%m/%Y"). The output column is coming as Null.

I even tried to use the date time tool, but it is not giving all the values in the required format. It is missing some values in between.
Also, I tried to change the filed type to Date but it is also not helpful.

Please suggest solutions for this.

[binu_acs · Accepted solution]

@Kartik21 use DateTimeParse([Field],'%m/%d/%Y') and change the DataType to Date

[ShankerV · Accepted solution]

Hi @Kartik21  Please use datetimeparse() function.

 

[Kartik21]

Thanks @binu_acs & @ShankerV . It is working fine now.