System Automaticlly recognise the time

julkifli33

hi all
i have a field type option
there is 3 option... 1st,2rd,3rd
can we automatically recognize the time?
if we create on 9AM -12PM --> 1st
12 PM - 3PM --> 2nd
3PM-6PM --> 3rd
6PM - 9AM --> back to 1st

mohana_cse06

You need to write the code something like (OnInsert or Onvalidate of any field)
IF TIME IN [9,12] then
Option = 1
ELSE IF TIME IN [12,3] THEN
Option = 2
ELSE IF TIME IN [3,6] THEN
Option = 3

julkifli33

mohana_cse06 wrote:

You need to write the code something like (OnInsert or Onvalidate of any field)
IF TIME IN [9,12] then
Option = 1
ELSE IF TIME IN [12,3] THEN
Option = 2
ELSE IF TIME IN [3,6] THEN
Option = 3

thanks a lot

julkifli33

mohana_cse06 wrote:

You need to write the code something like (OnInsert or Onvalidate of any field)
IF TIME IN [9,12] then
Option = 1
ELSE IF TIME IN [12,3] THEN
Option = 2
ELSE IF TIME IN [3,6] THEN
Option = 3

how about 11.30?
thanks