Text conversion to date

[UrsulaWhite]

Using the following to convert text to a date, but doesn't seem to work:

Date#("Caseload Date", 'DD/MM/YYYY') as "Caseload Date",

It is still in the original format DDMMMYYYY

[sidhiq91 · Accepted solution]

@UrsulaWhite  Please use below expression and see if it works.

Date(Date#("Caseload Date", 'DDMMMYYYY'),'DD/MM/YYYY') as "Caseload Date"

[UrsulaWhite]

Thanks appreciated - I know your solution works as I have just worked it out myself.