Date formatted as numbers

[qliky88]

Hi All, 

In my data set I have in my DATE_AUTHORISED column '20190726' etc.. (i.e. 26th July 2019)

How would I format this to a readable date? 

Thanks 🙂 

[tresB]

Try like:

Date(Date#(DATE_AUTHORISED, 'YYYYMMDD')) as DATE_AUTHORISED

[qliky88]

Hi @tresB , just inserted that into my script and it has returned only NULL values. In my data mnager the column is formatted as a date, but when I try to display the columns in a straight table it is only numeric values returned. 

[tresB · Accepted solution]

That means, your date field doesn't require a string parsing, you just have to get the formatting right. Check your date format variable :

Set DateFormat = 'MM-DD-YYYY'; // or the one of your choice