I want to seperate time range into two different fields

[#1]

I have a field holding time for example '8:00:00 am'. How do I sieve out all time below 8:30:00 am and does greater than 8:30:00am in another field.

[petter]

Do you mean in the Load Script or as an Expression in a chart?

[petter]

Data:

LOAD

  ID,

  If( Time( DateTime ) <  Timestamp#( '08:30' ) , TimeStamp(DateTime) ) AS Time0,

  If( Time( DateTime ) >= Timestamp#( '08:30' ) , TimeStamp(DateTime) ) AS Time1

;

// Just some auto generated test data that feeds into the LOAD above:

LOAD

  RecNo() AS ID,

  Date( MakeDate( 2015,1,1 ) + ( RecNo() - 1 ) / ( 24*6 )  ) AS DateTime  

AUTOGENERATE

  24*6*3;

[Gabriel]

Hi,

Can you kindly clarify what you want to? Tell community more or post sample data.

Community expert can give suggestion which is more accurate if they understood what you want to achieve.

I can suggest using this function

=IF(Timestamp(NOW(),'HH:SS:MM')> '19:27',1,0) which might be what you want to achieve, if you substitute NOW() with the fieldname.

So please explain what you want to achieve.

[#5]

I wanna seperate time >= 8:30 AM from time < 8:30 AM. both on different fields. Find attach please

Thanks

[#6]

Find attached

[petter]

I guess this is what you want to achieve?