DD/MM/YYYY Format help

[mahitham]

Hi Experts,

Can any one please help me on below Date formatting to convert to DD/MM/YYYY Format.

I have converted Original Date to DD/MM/YYYY Format like below

Date([Original Date],'DD/MM/YYYY')       as  [Converted Date]

But i am getting Duplicate Dates 30/12/9999 was repeated two times. please help me on this.

[Original Date]

9999-12-30 18:30:00 0

9999-12-30 23:00:00 0

9999-12-31 00:00:00 0

getting duplicates on  [Converted Date]

30/12/9999

30/12/9999

31/12/9999

Thanks in advance

[tresesco · Accepted solution]

Try this:

Date(Floor([Original Date]),'DD/MM/YYYY')       as  [Converted Date]