How can I compare the time of a date

[Anonymous]

I did the following

if(TimeStamp(LlegaCarga,'hh:mm:ss')>'18:00:00','M','N')

[johnw · Accepted solution]

Perhaps this?

if(frac(LlegaCarga)>maketime(18),'M','N')

[Peter_Cammaert]

or

if (frac(LlegaCarga) > 0.75, 'M', 'N')

relying on the fact that 6pm or 1800hrs is 3/4 of a single day.

[johnw]

Or almost like you had it. I think this works, but I'm less confident in it.

if(text(timestamp(LlegaCarga),'hh:mm:ss'))>'18:00:00','M','N')