Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm loading five CSV files, and I want to add the date the CSV file was creating to my script.
I've had a nosey through, but can only find 'Time' and not 'Date'.
How can I do this?
Thank you!
Di
Hi Diane, FileTime() returns date and time in the format specified in TimestampFormat variable (usually set at the beggining of script)
You can look into the QV file functions, like FileTime().
Should also give you the date (I believe it's returning a timestamp)...
You could get you csv's last modified date and time using the FileTime() function in your load load script.
Hi Diane, FileTime() returns date and time in the format specified in TimestampFormat variable (usually set at the beggining of script)
Hi,
Thank you!
Used:
Floor(filetime()) and set the format to date, and worked a treat!
Thank you everyone!