Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Need Help with a drop down list

Avatar

Avatar
Level 1
William_wm
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
William_wm
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
View profile
William_wm
Level 1

02-04-2014

Hi i have a form that uses a drop down list to change a date/time field that has been working for a long time but has recently stoped working.

The drop down list has 5 selections that change a date in the date/time field based off another date/time field untill recently has worked fine but now when selection 3-5 are selected the date shown is for example 1-14-1900.

Here is the code used

if (DropDownList1.rawValue == "1")then

          form1.Table2.Row3.DateTimeField1.formattedValue

 

elseif (DropDownList1.rawValue == "2")then

          form1.Table2.Row3.DateTimeField1.formattedValue

 

elseif (DropDownList1.rawValue == "3")then

          Num2Date((Date2Num(form1.Table2.Row3.DateTimeField1.formattedValue, "MMM DD, YYYY") + 14), "MMM DD, YYYY")

 

elseif (DropDownList1.rawValue == "4")then

          Num2Date((Date2Num(form1.Table2.Row3.DateTimeField1.formattedValue, "MMM DD, YYYY") + 21), "MMM DD, YYYY")

 

elseif (DropDownList1.rawValue == "5")then

          Num2Date((Date2Num(form1.Table2.Row3.DateTimeField1.formattedValue, "MMM DD, YYYY") + 25), "MMM DD, YYYY")

 

else null

 

endif

Any help would be appriciated.

View Entire Topic

Avatar

Avatar
Level 1
William_wm
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
William_wm
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
View profile
William_wm
Level 1

03-04-2014

What is odd is my code starts to work again at april 10th.