Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Do you mean in the Load Script or as an Expression in a chart?
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;
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.
I wanna seperate time >= 8:30 AM from time < 8:30 AM. both on different fields. Find attach please
Thanks
Find attached
I guess this is what you want to achieve?