LOAD: Where timestamp >=8:00<=16:00

[#1]

Hi,

trying to load only the relevant data, which means transactions only made between 08:00 and 16:00.

However do not understand how to use the WHERE statement on timestamps.

Any ideas?

Example data and QV-file attached

Regards,

Olle

[Anonymous · Accepted solution]

Hello,

Directory;

LOAD Amount,

     [Settlement timestamp],

     hour([Settlement timestamp]) as hour

FROM

[filter time example.xls]

(biff, embedded labels, table is [Report 1$])

where hour([Settlement timestamp])>=8 and hour([Settlement timestamp])<16

;

BR

Serhan

[Anonymous]

Hola,

PFA

HTH