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
