Hello, how can I compare one timestamp to a given one?
For example, I'm asked to check for this:
aggr(timestamp(max([tmsp]),'DD/MM/YYYY hh:mm:ss.ffffff'),[id]) to this same max timestamp per id but for 8 o clock in the morning.
This
If(aggr(timestamp(max([tmsp]),'DD/MM/YYYY hh:mm:ss.ffffff'),[id]) <aggr(timestamp(max([tmsp]),'DD/MM/YYYY 08:00:00.000000'),[id]) ,'yes','no')
doesn't work!
