Calculate the Date

[jnariss]

I am trying to calculate the date in my InfoPath form. I can easily calculate
todays date using the function: today( ) but how do I add 3 days to that date?
?

Thanks,
Justine

 

[John Vinson]

I am trying to calculate the date in my InfoPath form. I can easily calculate
todays date using the function: today( ) but how do I add 3 days to that date?
?

Thanks,
Justine

Are you using Microsoft Access? InfoPath is a different program;
perhaps you need to ask in an InfoPath support forum.

John W. Vinson[MVP]

 

[jnariss via AccessMonster.com]

I'm using Access Database with an InfoPath form. I'll just ask another room
based on InfoPath Help- no one seems to know anyways.

Thanks for relplying.

 

[John Vinson]

I'm using Access Database with an InfoPath form. I'll just ask another room
based on InfoPath Help- no one seems to know anyways.

In an Access Form or Query, you can use DateAdd("d", 3, [datefield]);
if the data is stored in Access, try just adding 3 to the date field.
An Access Date/Time is stored as a number, a count of days and
fractions of a day (times) from December 30 1899.

John W. Vinson[MVP]

 

[jnariss via AccessMonster.com]

Thanks for replying - I will try that. I am currently trying to develop
another form. Too many databases and forms to create!!!!!

Happen to know anything about the SendObject action?

-Justine

I'm using Access Database with an InfoPath form. I'll just ask another room
based on InfoPath Help- no one seems to know anyways.

In an Access Form or Query, you can use DateAdd("d", 3, [datefield]);
if the data is stored in Access, try just adding 3 to the date field.
An Access Date/Time is stored as a number, a count of days and
fractions of a day (times) from December 30 1899.

John W. Vinson[MVP]

 

[John Vinson]

Happen to know anything about the SendObject action?

Not much - try posting a new thread so someone who does will reply.

John W. Vinson[MVP]