Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Have a question,
how to work this situation.
I have a table with the below fields:
Dimension1,
Date, MM/DD/YYYY HH:MM:SS
Landmark, 'A'-'Z'
Start Timestamp,MM/DD/YYYY HH:MM:SS
End Timestamp.MM/DD/YYYY HH:MM:SS
I have to distribute DImension 1 into Day and Night
if ( ( Date greater than min({<Landmark = 'D'>}Start Timestamp)
and
( Date less than max({<Landmark = 'Y'>} End Timestamp) ),
'Day','Night').
How can this be achieved.
Thanks,
Garry
Is this something you are looking to do in the script or front end app? Also, are you able to share a small sample to show your data looks like?