topic Re: Time Adding 4 hours to File Date in QlikView

Time Adding 4 hours to File Date

Tue, 11 Mar 2014 12:25:40 GMT

How to Add 4 hours time to my File Date.

I need to Add 4 hours time for this below one .

File_time:

LOAD

date(left(filetime(),10), 'YYYY/MM/DD') as File_Time_WMS_INV

FROM

[$(Publisher_Data)Bedford\WMS\Bedford_inventory_EXTRACT.csv]

(txt, codepage is 1252, no labels, delimiter is ',', msq);

Last reload ='Last reload : ' & Date(ReloadTime(), 'DD/MM/YYYY hh:mm:ss') & ' (CET)'

tresB — Tue, 11 Mar 2014 12:30:31 GMT

May be like:

='Last reload : ' & Date(ReloadTime()+Time#(4,'h'), 'DD/MM/YYYY hh:mm:ss') & ' (CET)'

rbecher — Tue, 11 Mar 2014 12:31:44 GMT

Hi,

just add 4/24. One day=1.

LOAD

date(left(filetime() + 4/24,10), 'YYYY/MM/DD') as File_Time_WMS_INV

Btw. I wouldn't add 1/6 (same value) for better reading..

- Ralf

jagannalla — Tue, 11 Mar 2014 12:49:26 GMT

Hi,

Just add

Date(FileTime()+(4/24),'M/D/YYYY h:mm:ss[.fff] TT') as FileTime_FourHrs

If you don't want date just remove date format from listed format.

Thanks,

Jagan

Tue, 11 Mar 2014 14:49:08 GMT

Thanks Tresesco ,for reload its working fine ,but filetime() its not working ,its little bit urgent ?