Conversion of DATES in LOAD SCRIPT

[lakshmanvepuri]

HI All,

Please let me know how to attain this in the LOAD SCRIPT.

FROM DATE to TO_DATE

FROM DATE	TO_DATE
10/01/2020 01:43:54 AM	10/01/2020 12:00:00 AM
10/01/2020 01:49:51 AM	10/01/2020 12:00:00 AM
10/01/2020 01:50:48 AM	10/01/2020 12:00:00 AM
10/01/2020 10:38:57 PM	10/01/2020 12:00:00 AM
10/02/2020 12:19:14 AM	10/02/2020 12:00:00 AM
10/02/2020 01:22:25 AM	10/02/2020 12:00:00 AM
10/02/2020 11:16:14 PM	10/02/2020 12:00:00 AM
10/03/2020 12:03:53 AM	10/03/2020 12:00:00 AM
10/03/2020 09:11:17 PM	10/03/2020 12:00:00 AM
10/03/2020 09:23:43 PM	10/03/2020 12:00:00 AM

Thanks a lot

Vepuri LK

[Nicole-Smith · Accepted solution]

You can use the DayStart() function:
DayStart([Date Field])

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFu...