compare time

[Anonymous]

I have a list of time and want to know if they are in the future or past compare to now.

so expecting to see:

any idea, I tied to play with the interval function but not sucess yet...

Thanks

Raphael

LOAD * INLINE [

    MyTime

    01:00

    05:00

    10:00

    15:00

    20:00

];

[sergio0592 · Accepted solution]

Hi,

Use as expression :

if(time#(MyTime,'HH:MM:SS')<time(Now()),'Past','Future')

See the attached .qvw.

Regards

[tresesco]

Try:

If(MyTime>=Frac(Now()), 'Future', 'Past')

[Anonymous]

Many thanks!

[thevingo]

Hi

I know its already answered, but the solution doesn't work for me. My solution is:

Load *, If(Diff>0, 'Future', 'Past') as Flag_TIME;

Load *, Num(MyTime)-num(Time(Now())) + Num(Today()) as Diff, Time(Now()) as Now;

LOAD * INLINE [

    MyTime

    01:00

    05:00

    10:00

    15:00

    20:00

];

The result is