Creating Flag for Time

[rajkumarb]

Hi All

i have  a time field SoldTime(dd-mm-yyyy hh:ss:fff), i need to create a flag for that field in the load script

if sales made before 12:00 = Y

and sales made after that =N

Please suggest how to do that

[swuehl · Accepted solution]

Set TimestampFormat = 'DD-MM-YYYY hh:mm:ss:fff'; // or whatever your real format is

LOAD

     SoldTime,

     If( Frac(SoldTime) <0.5, 'Y','N') as Flag,

     ...

[Gysbert_Wassenaar]

Perhaps like this: If(Frac(SoldTime)<0.5,'Y','N') as Flag