Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I did the following
if(TimeStamp(LlegaCarga,'hh:mm:ss')>'18:00:00','M','N')
Perhaps this?
if(frac(LlegaCarga)>maketime(18),'M','N')
or
if (frac(LlegaCarga) > 0.75, 'M', 'N')
relying on the fact that 6pm or 1800hrs is 3/4 of a single day.
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')