topic Getting a Date from The CSV File I'm Loading in QlikView

Getting a Date from The CSV File I'm Loading

dinicholls — Mon, 09 Nov 2015 11:43:21 GMT

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!

swuehl — Mon, 09 Nov 2015 11:45:22 GMT

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

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

Anonymous — Mon, 09 Nov 2015 11:45:30 GMT

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

rubenmarin — Mon, 09 Nov 2015 11:48:31 GMT

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

dinicholls — Mon, 09 Nov 2015 11:58:44 GMT

Hi,

Thank you!

Used:

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

Thank you everyone!