Newbie Questions

Re: Copying a date field from one form to another

warrtalon — Wed, 01 Jul 2009 21:25:49 GMT

Yes, such logic should have worked, but MS code can be finicky at times.

Re: Copying a date field from one form to another

DavidSea2 — Tue, 30 Jun 2009 18:54:55 GMT

That was it - Thank you so much - I'm still a little confussed why - if I had the field formatted for date and time, shouldn't that have worked?

Re: Copying a date field from one form to another

warrtalon — Tue, 30 Jun 2009 14:18:22 GMT

Use substring-before(DateField," ") to strip out the time and try to add that date value in to a date field.

Re: Copying a date field from one form to another

DavidSea2 — Tue, 30 Jun 2009 13:54:57 GMT

This is it - 2009-07-06 00:00:00 – Again the receiving form control is Text Box formatted as Date&Time, the original form is Date Picker formatted display XML. However, I have tried numerous format combos with both fields.

Re: Copying a date field from one form to another

warrtalon — Mon, 29 Jun 2009 23:34:15 GMT

What does the copied data look like when it copies into the new form's date field?

Copying a date field from one form to another

DavidSea2 — Mon, 29 Jun 2009 14:53:29 GMT

Good Morning All - I have a form that is used to request funding for a project that was previously submitted on a separate form (funding request is not always needed, so it is not included in the project form). I have a look up on the Funding form that copies the topic information from the Project form to the Funding form - the problem is the Project date field - it copies just fine, but the field highlights in red - as an error - stating "this field must be date" only". I've changed the formating (on both forms) to "date","date and time", Display XML. I haven't gotten any combination to work. If I change it to a text field, I don't get the error - then it works fine (I need the date for filtering and sorting).

I am using Infopath 2003