Time Adding 4 hours to File Date

[#1]

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)'

[tresesco]

May be like:

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

[rbecher]

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]

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

[#5]

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