Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a date field in the format DD/MM/YYYY hh:mm:ss, I need to segregate time based on inoffice and outoffice
for IN OFFICE condition is " 8:30 am to 7:30 pm and rest of the time should come under OUTOFFICE.
I should get the table layout as follows:
date COLUMN1
-----------------------------------------------------------------
04/12/2018 08:30:23 INOFFICE
04/12/2018 20:08:23 OUTOFFICE
For this under , COLUMN1 expression tab I am applying following condition
=if(time(date) >= '08:30:00' and time(date)<= '17:30:00' ,'InOffice',
if(time(date)>= '17:31:00' and time(date)<= '08:29:00' ,'InOffice'))
This condition is coming out to be OK in the expression tab, but I am not getting the values in the front end under COLUMN1.
pls suggest me if there is any other method by which I can implement this.
Thanks