I need to limit the users to enter the data for say last one week. Have tried Field(current date)-7 in validation but does not trigger an error. Please help!
Hi shashikant,I usually use a date validation error with a condition like this: field1 > addDays(today(), -7)
Would this approach work for you?Regards,
Thank you so much. I have tried this as well but somehow it is not working. I am new to InfoPath. I have a form where there are two date fields & it will be used for saving exceptions for defects. Now I need to ensure that no one is able to enter any exception more than 7 days prior to current date(Today). Field 1 is today & Field 2 is the date of exception.
Please help!
Hi shashikant,
If you are using field1 as the date for today, you will have to use this formula instead:
field2 > addDays(field1, -7) Hope this helps.
Thank you so much! That was perfect!