InfoPath Dev

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 ...

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

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 ...

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

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?

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")

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))), ...

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 ...

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, ...

Hello Tenbao, Yes, we had this problem in the earlier versions of DBXL but we have implemented a fix for v2.9 and later. Please upgrade and see if that resolves the issue. If not, then let us know and we will be happy to help you. Also, feel free to contact us if you need any help for the upgrade. Thanks! Kind ...