I am designing an form in which a user enters a date by selecting it on a date picker. When the user enters the date I want the form to update another field with the week number which is in the form e.g. 2013051, which represents day 1 of week 5 in 2013. I have stored the week numbers in share point list with relevant dates. I have a rule on the the date picker field as follows:
update field(weekNumber) with weekNumber
where the dateFormCompleted
(which is the field on the date picker that users use to select date
) is equal to dateOnSharePointList.
The weekNumber is not being updated. My initial thoughts are that the date format that is shown on the date picker is NOT the same as the format that is stored in the Sharepoint List - dd/mm/yyyy.
I have a created a test field to check the date format returned when a date is selected with a date picker - seems the visual format on the date picker is not the same as tha returned. See value on the datePicker Test field
I assume that when the rule for updating the weekNumber
is executed it gets confused because of different date formats.
Please can someone help me, I have spent days trying to resolve this. I still fairly new to using infopath