This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How do I convert 09222018 to a date? I can't get the string to date function to work because I think I have to have it in yyyy-mm-dd format. I tried different ways and cannot achieve this. I also tried the datetimeparse formula, but keep getting a null value.
Can anyone guide me how to convert the format from 2019-02-26 to a date format like this: ddmmmyy (i.e.,26Feb19)?
I tried to use DateTimeParse "DateTimeParse([Incurred From Date],"%d,%b,%y")", but there's a warning message saying cannot convert "2019-04-22" to a date /time with format "],"%d,%b,%y": Expected separator , ],"%b,%y, got '19-04-22'.
I even tried to use the select tool to change the format to date first, but the result keep showing null.