Not applicable

Why is Query XML changing the format of date?

We have a day off request where associates can select multiple day offs in one request. this is done by using a repeating section in the form. We then query the information from the repeating section into html and store it into a variable. Then we update the column with displaying the html information.


This is how the information is shown in the column. It works great! But we need to go one step further.

Image 1.jpg

We one another column to display ONLY the first Day Off Date Requested(We can have up-to 14 requested days). The reason being is because we want to sort by the first requested day, rather than created by.

We have tried...

1)substring(DayOff,4,3)+""+substring(DayOff,7,3)+","+substring(DayOff,23,5)----- this code in the form value. It displays the data as FEB 11, 2016. We want 2/11/2016 but cannot get it to work. We do not know why the site is formatting to say the month as FEB and not 2.

2) We have thought about querying another variable and then pulling the information for just the fist date, didn't work.

3) we had an if then formula to change the FEB to 1 on all months, didn't work.

Just wondering if anyone knows how to make this work?

Thanks,

Jacob

0 Kudos
Reply
2 Replies
tbeduneau
Nintex Newbie

Re: Why is Query XML changing the format of date?

Not sure I understand your need well....but if your talking about date display in the SHarePoint list, you can change it in the list settings :

- find your date column

- change Display format from "Firendly" to "Standard"

0 Kudos
Reply
Not applicable

Re: Why is Query XML changing the format of date?

The "Day Off" column type that we are using to query the XML is Single line of text. I wish it gave us the option to change the Display format but sadly there is not.

0 Kudos
Reply