Date format is not working!

[hi2019]

Hi,

Issue date is a Vstring 20201230 format- using datetime tool from string to date with custom %m%D%Y -- it is not workign-- it is NULL

Please help

[Raj · Accepted solution]

@hi2019 
use datetimeparse to get this in date format

DateTimeParse([your column],"%Y%m%d")


mark done if solved.

[Hub119]

Try "%Y%m%d" as your string appears to be year, month, day, instead of month, day, year.