Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Need Help with a drop down list

Avatar

Level 2

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.

5 Replies

Avatar

Level 7

You have a space in the word 'value' in 'formattedVal ue' for boxes 3-5.

Avatar

Level 2

In the code on the form there is no space i am not sure why it has on there as i copy and pasted the code here.

Avatar

Level 7

You haven't said where you are putting this code, but if it is in a third field (where you want the results to go) then try this:

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

Avatar

Level 2

This code has the same problem as the one i have.

The code is in the second  date field that is a due date which depends on the inpute of the dropdown list and the current date that is in the first date field.

Avatar

Level 2

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