Newbie Questions

Re: After calculating date field validation error in Infopath Designer

adit123 — Mon, 11 May 2015 13:04:07 GMT

Thank you! It worked perfectly!

Re: After calculating date field validation error in Infopath Designer

Hilary Stoupa — Thu, 07 May 2015 22:32:43 GMT

SharePoint lists will let you display a date time as a date only value - but in the end, the data type is date time.

Re: After calculating date field validation error in Infopath Designer

adit123 — Thu, 07 May 2015 22:22:07 GMT

Oh is that the default setting through SP? Okay I will try this . Thank you!

Re: After calculating date field validation error in Infopath Designer

Hilary Stoupa — Thu, 07 May 2015 22:18:50 GMT

So, when you say "my form is created through SharePoint" do you mean this is a list form?

If so, I'd assume that any date field is actually a date time.

Try adding "T00:00:00" to the end of your concat formula and see what happens.

Re: After calculating date field validation error in Infopath Designer

adit123 — Thu, 07 May 2015 22:15:35 GMT

Hello Hilary, so I was replicating the form in a blank infopath filler, and when i was applying the same rules, it worked! I can not send you my acutal form due to privacy issues , but my form is created through Sharepoint maybe that is why I am receiving such a validation error? In the blank Infopath Filler form, it was completely fine! No validation error. This is strange. Any reason why you think this is happening?

Re: After calculating date field validation error in Infopath Designer

Hilary Stoupa — Thu, 07 May 2015 21:58:22 GMT

Can you attach your template under the options tab in a reply?

Re: After calculating date field validation error in Infopath Designer

adit123 — Thu, 07 May 2015 21:52:54 GMT

Correct. So I have two fields. One is a text box where I set a rule and does the replacing of the day, so using your function. and then the other is a "Date Only" field where in the default value I just make it equal to the text box field. I am not sure where I am going wrong with this. I also tried the your formula directly on the Date Only field and received the same validation error.

Re: After calculating date field validation error in Infopath Designer

Hilary Stoupa — Thu, 07 May 2015 21:48:07 GMT

What is the data type of the field you are trying to set with this rule? Date or Date Time?

Re: After calculating date field validation error in Infopath Designer

adit123 — Thu, 07 May 2015 21:40:52 GMT

I placed in your function, but I am still receiving the validation error :( . Now it is just showing up as "2016-05-28" . Is this because the Date type box sees this as a string rather than an actual date?

Re: After calculating date field validation error in Infopath Designer

Hilary Stoupa — Thu, 07 May 2015 21:33:45 GMT

And what I am saying is that you get a validation error because your formula is not returning a correctly formatted date.

concat(substring(Calculated Cal. Due Date, 1,4), "-", substring(Calculated Cal. Due Date,6,2), "-28")

Re: After calculating date field validation error in Infopath Designer

adit123 — Thu, 07 May 2015 21:27:13 GMT

Sorry, I should clarify more. I basically want to replace the day, from a calculated text box field which is in yyyy-MM-ddThh:mm:ss , and now I want to replace it with the day 28. I realized February would not have 30 days. So once I replace the day using this function:

concat(number(substring(Calculated Cal. Due Date,6,2))), "/28/", number(substring(Calculated Cal. Due Date, 1,4)))

, I set the default value of a Date type field equal to the text box where I replaced the day with the 28.

Re: After calculating date field validation error in Infopath Designer

Hilary Stoupa — Thu, 07 May 2015 21:05:04 GMT

Regardless of how a date is displayed on the form (the formatting settings) the format for a date datatype in XML is:

yyyy-MM-dd

So, you want both of the characters for month instead of just one, and you want year, then month, then "30", all hyphen separated.

Look at an XML file in a text editor and you'll see how the dates are formatted.

DateTime format (for completeness):

yyyy-MM-ddThh:mm:ss

After calculating date field validation error in Infopath Designer

adit123 — Thu, 07 May 2015 20:03:33 GMT

I am trying to do a calculation where the date always gets calculated to the 30th of a month so, I am using this formula in a text box,

concat(substring(Calculated Cal. Due Date, 7, 1), "/30/", substring(Calculated Cal. Due Date, 1, 4))

Then I created a Date picker box and in it's default value, I made it equal to the text box, however I am receiving a validation error where it is showing red dashes around the Date Picker box. Also when a calculation is made, it is in the correct format , "mm/dd/yyyy". Even with the consistent formatting, there is a red dash , showing a validation error. I am not sure what i am doing wrong.