Newbie Questions

Re: Validate future date.

Kalyan Gaddam — Fri, 05 Oct 2007 06:00:12 GMT

Since there are no functions in Infopath to do this you have to use Code to do this

public void date_OnValidate(DataDOMEvent e)

{

// Custom data validation because InfoPath does not have functions for date arithmetic

if (e.Operation == "Insert")

{

try

{

DateTime date = DateTime.Parse(e.NewValue.ToString());

if (date.CompareTo(DateTime.Today.AddDays(5)) > 0)

{

e.ReportError(e.Site, "Date cannot be more than 5 days away.",

false, null, 1, "modal");

}

catch (FormatException)

{

i hope it helps you

Re: Validate future date.

Clay Fox — Tue, 02 Oct 2007 16:20:13 GMT

What I would do is use the datediff to calculate a field on load that is Today +5 then you can use a rule or code to validate if the entered date is greater than the calculated date.

Validate future date.

TheSkev — Tue, 02 Oct 2007 13:28:55 GMT

Hi there,

I have created a form in InfoPath 2003 and need to validate that the date selected (in a datepicker) is greater than today, but not more than 5 days in the future.

I have created a validation event that uses the 'today()' function and set it to check error if the selected date is 'less than or equal to today()'. This works fine. The problem comes with the next part. I have created a 2nd validation event that checks whether the date 'is greater than today() + 5' but this doesn't work.

I have hunted around on this forum and found some VBscript information that sounded like it may do the trick, however the 'OnValidate' or 'OnAfterChange' events don't seem to fire.
Any help would be much appreciated.

Many thanks,

Skev