Date Calculation

[mjahani]

Hi,

I'm using Infopath 2003 and would like to perform a date comparison. The
first date is called DATE_SUBMITTED and comes from a database and the second
one is today's date. I want to perform a date compare like the one below as
part of a filter:
IF DATE_SUBMITTED is greather than Today's date minus 21

How can I do this? Thanks

 

[Sandhya]

Hi,

Can you go through this below lin
http://enterprise-solutions.swits.n...p?t=datediff-vbscript-infopath&c=infopath2003
It may help you.

Thanks,
Sandhya
http://www.ggktech.com

 

[mjahani]

Hi,

This works but it uses 2 date pickers. What I'm looking for, is to use a
date that comes from a database and today's date. Is there anything
describing this one?

 

[BhanuY/+919985103237]

You can use the same DateDiff function before that bind the first Date picker
to the value coming from DB.