Getting a Date from The CSV File I'm Loading

[dinicholls]

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

[swuehl]

You can look into the QV file functions, like FileTime().

Should also give you the date (I believe it's returning a timestamp)...

[Anonymous]

You could get you csv's last modified date and time using the FileTime() function in your load load script.

[rubenmarin · Accepted solution]

Hi Diane, FileTime() returns date and time in the format specified in TimestampFormat variable (usually set at the beggining of script)

[dinicholls]

Hi,

Thank you!

Used:

Floor(filetime()) and set the format to date, and worked a treat!

Thank you everyone!