'01JAN2020:00:00:00'. How do i change this date format to 'DD/MM/YYYY'?

[Amelia_96]

Hi, i have data with date '01JAN2020:00:00:00'. How do i change this date format to 'DD/MM/YYYY'? And i also need to filter this date but i cannot. Please help

[tresesco]

Date(Date#('01JAN2020:00:00:00', 'DDMMMYYYY:hh:mm:ss'), 'DD/MM/YYYY')

[Amelia_96]

Thank you so much!!