set a dimension with Max and min values

[garry107]

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

[sunny_talwar]

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?