Help converting unusual date format

[Javery]

Hi All,

I'm looking for advice as to how I can convert date/times in this format:

'23 Jan 22, 10:20'

Into a standard DD/MM/YY. I've looked through lots of documentation to try to figure this out but can't seem to get there.

Any help greatly appreciated.

Best,

J

[Mark_Little · Accepted solution]

Hi @Javery 

I would probably go for something like

Date(Subfield(Date,',',1),'DD/MM/YYYY')

[Javery]

Much appreciated @Mark_Little !

[BrunPierre]

Like this

Date(Date#(Timestamp,'DD MMM YY, hh:mm'),'DD/MM/YY')