if condition not working

[#1]

Hi Experts,

I m trying to write if condition for a time like below in the script

if(DeliveryTime >= '10:00:00' and DeliveryTime <= '15:00:00' ,1,0) as Flag.

but this is not working. Is anything wrong in the expression?

Can someone please help

[sorrakis01]

Can you upload an example? or try this Time#(DeliveryTime,'hh:mm:ss') as DeliveryTime

[#3]

what should i use if i have time in this format

42747.582638889

[sorrakis01]

Hi Pr,

This is your format? Wich is the original data? Oracle? Unix? It's a concatenate field?

Regards

[#5]

yes. this is my format. data is from sql

[sunny_talwar]

May be this:

If(Frac(DeliveryTime) >= MakeTime(10) and Frac(DeliveryTime) <= MakeTime(15), 1, 0) as Flag.

[susovan]

You can also try this process ,

Time:

LOAD Time as @_Time

FROM

Table3.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD *,

if(Timestamp(@_Time,'hh:mm:ss')='10:00:00' and @_Time,'hh:mm:ss')='15:00:00',1,0) as @_Time_Flag

Resident Time;

[#8]

no sunny.

Not working.

I have attached sample data.

Please help

[#9]

its not working

[sunny_talwar · Accepted solution]

Seems to be working for me

Table:

LOAD [Delivery Id],

    TimeStamp([Delivery Time]) as [Delivery Time],

    If(Frac([Delivery Time]) >= MakeTime(10) and Frac([Delivery Time]) <= MakeTime(15), 1, 0) as Flag

FROM

[..\..\Downloads\Time test.xls]

(biff, embedded labels, table is Sheet1$);

[annafuksa1]

Please check my app