Date Time formet

[farzeenabbas]

i have this date time format '20220131163500' how to convert this in simple date into load script . i only need date  from this.

[MarcoWedel · Accepted solution]

Date(Date#(Left('20220131163500',8),'YYYYMMDD'))

[farzeenabbas]

yeah ,it works Tysm @MarcoWedel