Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate Date by adding numeric field

Status
Not open for further replies.

VisaManiac

Technical User
Aug 12, 2001
14
0
0
US
I have a simple request that I can't seem to locate the right option for the calculation to work.

I just need 3 simple fields.

Due Date + 31 days = New Date

The Due Date & the New Date fields are formated to display as mm/dd/yyyy, and the 31 days field is a numeric read-only field because I don't want this to be changed by the user. I've also set the 'New Date' properties to calculate the SUM of Due Date & 31 days, but I keep getting this pop-up:

"Invalid date/time: please ensure that the date/time exists. Field [NewDate] should match format mm/dd/yyyy."

Also, the NewDate isn't calculating the Due Date + 31 days.

I don't know java so don't know what the script should be plugged in. Any assistance would be greatly appreciated.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top