PDA

View Full Version : date adjustment for a report


ABC123

Andy Neufell
07-27-2000, 05:13 AM
I would like to adjust a ship to customer date in a report. The report is from a set that contains a delivery dbf and a part dbf. I would like to run a report that adjusts the customer date (in the del dbf) by a numeric field (in the part dbf). For each part this number will be different otherwise I would just use a calculated field {datedue-3 for example}. I have tried the following calculated field and it does not adjust the date but only returns the original date. datedue-(part->adjnumber). Any suggestions???

Melvin Davidson
07-27-2000, 05:31 AM
Andy,

I'm not sure why this isn't working.

Check the following.
If the datedue field is part of the db,
then change the formula to:

deldbname->datedue-(part->adjnumber).

If it's a variable, make sure you've done

DIM datedue d

at the beginning of the script.

You can also try to adjust your formula as follows:

DATE(datedue)-(part->adjnumber).