System Automaticlly recognise the time

julkifli33
julkifli33 Member Posts: 1,100
edited 2011-04-18 in NAV/Navision Classic Client
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

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    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

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • julkifli33
    julkifli33 Member Posts: 1,100
    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
    julkifli33 Member Posts: 1,100
    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

Categories