Newbie Questions

Re: date time validation could not be achieved

ErnestoM — Tue, 30 Apr 2013 12:55:32 GMT

I don't understand your question.

Did you try my advice above?

Re: date time validation could not be achieved

irshadpeeran — Tue, 30 Apr 2013 11:17:01 GMT

Hi,

may I know how to preview form xml and secondary data source xml.

should I have to export form. any easy tool is there

kindly suggest

Re: date time validation could not be achieved

ErnestoM — Fri, 26 Apr 2013 13:22:42 GMT

You'll have to look at the actual xml values being stored in your form for the dates. You could have this in the secondary data source:

2012-02-01T01:23:34

But have this in the main data source:

2012-02-01

or even

2012-02-01 01:23:34

In which case, there's no match.

Simply drag both into the canvas and display their raw XML value (not the formatted date) in order to compare them.

Re: date time validation could not be achieved

irshadpeeran — Fri, 26 Apr 2013 10:05:07 GMT

Hi,

Sorry for bit confusing. I have attached the partial screen shot meaning the validation worked with title but not with date.

Rule:

Any Occurance of Title is equal to testtitle(field)

Any Occurance of Date is equal to testdate(field)

so if the same title occurs rules are applied to show error but for the title the error is not shown.

Steps that I did

1) created a data connection to the sharepoint list in infopath

2) created two fields with their date(Date and Time) and title(Text)

3) set validation rules:

Any Occurance of Title is equal to testtitle(field)

Any Occurance of Date is equal to testdate(field)

4) preview

please suggest some steps to achieve date validation against list in sharepoint.

Thanks,

Re: date time validation could not be achieved

ErnestoM — Thu, 25 Apr 2013 14:13:46 GMT

I'm a little confused. The first screenshot shows a validation rule on the date field, but the second screenshot shows a validation error in the second field?

Re: date time validation could not be achieved

irshadpeeran — Thu, 25 Apr 2013 07:15:19 GMT

Hi This is second snap shot I am attaching through options tab.Please look the title and date column of the list and the corresponding fields in infopath

Re: date time validation could not be achieved

irshadpeeran — Thu, 25 Apr 2013 07:13:34 GMT

Hi thanks for reply. I have attached the image through options tab.but it is not showing in preview

Re: date time validation could not be achieved

ErnestoM — Wed, 24 Apr 2013 12:31:26 GMT

The screenshots are not showing. Could you repost?

date time validation could not be achieved

irshadpeeran — Wed, 24 Apr 2013 07:25:40 GMT

Hi I could not perform validation on a date time field but for other fields I could validate(attached a snap shot).

I have added list through infopath data connection and I have set rule

Any Occurance of Date is equal to testdate(field)

the field type in info path is date and time also the format is US time format

Could anyone suggest me the approach

here is the out come