Custom Field (Date)

[Guest]

I have a query similar to the following:

Client FYE Grace Period (Days)
12/31 120
06/30 60
09/30 90
03/31 120

I would like to build a custom field that would calculate
a "Due Date" by taking the month and day (note that the
year is not important)and adding the number of days given
in the grace period similar to the following:

Client FYE Grace Period (Days) Due Date
12/31 120 04/30
06/30 60 08/29
09/30 90 12/29
03/31 120 07/29

Any suggestions as to what functions (or other
alternatives) could accomplish this. Thanks.

Jason

 

[Duane Hookom]

Check Help (in a module) for date functions. DateAdd() might be a good place
to start.