How to get unique date format

[venkatbza]

Hi Friends,

how to get unique date format for below attached screen print?

[OmarBenSalem]

have you tried:

date(YourField)

[sunny_talwar · Accepted solution]

Or try this

Date(Alt(Num(DateField), Num(Date#(DateField, 'DD/MM/YYYY')))) as DateField

[venkatbza]

Hi Omar,

Thanks for your reply, date() is not working here because in my date column having number format and text format so that's way date() and Date#() is not working. i need a solution like if a column have text format and number then it should convert into one unique date format.

[venkatbza]

Thanks Stalwar, its working.