Solved How to format Date to UK dd-mm-yyyy (1 Viewer)

[Number11]

Hello,

I need to change the formatting of this strange date layout to standard uk date

2021-11-24T01:00:00.000Z

2021-12-13T11:18:10.684Z

 

[arnelgp]

CDate(Left$([DateField], Instr(1, [DateField], "T")-1)

then use your Regional setting to set the Date format to UK.

 

[Number11]

CDate(Left$([DateField], Instr(1, [DateField], "T")-1)

then use your Regional setting to set the Date format to UK.

doesn't seem to work getting syntax error on CDate

 

[arnelgp]

add another ) at the end:

CDate(Left$([DateField], Instr(1, [DateField], "T")-1))

 

[Number11]

add another ) at the end:

CDate(Left$([DateField], Instr(1, [DateField], "T")-1))

nope

 

[Minty]

If you want to retain the time data try (from the immediate window)

?cdate(left (Replace ("2021-11-24T01:00:00.000Z","T"," "),19))
24/11/2021 01:00:00

In a query
CDate( Left (Replace ([DateField],"T"," "),19))

 

[Number11]

If you want to retain the time data try (from the immediate window)

?cdate(left (Replace ("2021-11-24T01:00:00.000Z","T"," "),19))
24/11/2021 01:00:00

In a query
CDate( Left (Replace ([DateField],"T"," "),19))

Thank you that did the job

 

[arnelgp]

nope

remove the $ sign.