How to change 2022-03-11 to 03-11-2022 format using datetime tool as it is giving null val

[Sunithaprdp]

when i am trying datetime tool, it is giving null value as result . How to get the date format to the one as mentioned above. mm-dd-yyyy is the format that I want as an output. Please do help.

[Emmanuel_G]

@Sunithaprdp 

I think that the issue comes from the format to convert in the datetimetool and the selected format for the new output.

I did two tests( Find it attached ). With formula tool and dateTimetool to achieve to desired output.

Let me know if it works as you want.

[binu_acs · Accepted solution]

@Sunithaprdp One way of doing this with the DateTimeParse and DateTime function

[Sunithaprdp]

@binu_acs thanks for the solution, it worked ! :)