Dates

[slickp]

I'm trying to create a debters report for our accounts department to let us know who owes us money. We have an effective date which is when the insurance policy is activated and we allow our clients 90 days to pay. So i've created a formula which adds 90 days to the effective date.

however we pay the insurers in the 25th of each month so if the date after 90days was the anything after the 25th of the month we would allow them up to the 25th of next month to pay i.e. date after 90 days 30th april so allow them to 25th may to pay.

Is there any formula in which i can take this date after 90 days and create a field which will show the pay date on the 25th of the correct month?

Sorry the post is so long, cheers

 

[Madawc]

You can derive it from the date {@90DAY}, using DatePart or specific commands for day, month and year. Try

If Day({@90DAY}) > 25
then 
DateAdd("m", 1, (Date((Year({@90DAY}), Month({@90DAY}), 25))
else Date((Year({@90DAY}), Month({@90DAY}), 25)

This allows for December dates after the 25th.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10