I have a field in general format , example:
|20 Mar 2012|
It is not in date format, so I need to convert this to date format, somehow my script failed to do so.
Appreciate if anyone could help!
Left([Added On], 2) as TempDay,
TextBetween([Added On], ' ', ' ') as TempMonth,
mid([Added On], 😎 as TempYear
(ooxml, embedded labels, header is 1 lines, table is Table1);
TempDay & '-' & TempMonth & '-' & TempYear as TempDate
date(TempDate) as Date
Drop table TempDate;
Solved! Go to Solution.