Stuck on date calculation!

[fmjusfloruit]

Problem: I need to create a date calculation for a simple invoice solution I am working on. I need to be able to calculate a date 45,60 days from today. When I try it, I get a returned result with "0001" as the year. Any thoughts? Thanks!

Mark

FileMaker Version: 6

Platform: Mac OS X Jaguar

[CobaltSky]

Hello Mark,

To produce the date 45 days from the current date, I suggest you use the formula:

Status(CurrentDate) + 45

...and make sure the calculation result type is date (or the field that the result is being placed in is a date field if you are doing this by script).

[fmjusfloruit]

Ray-

Thanks for your suggestion, I will give it a try today!

Mark

[fmjusfloruit]

Ray-

Just a quick follow-up, your advice worked perfectly!

Thanks again.

Mark

[CobaltSky]

No problem, Mark. Glad I could help.

FileMaker Version: Dev 7