Month From Date 1

[ganjass]

Can anyone help i am looking to create a report with the record selection criteria 1 month from the current date, is there an easy way to do this i've tried

{debt.dt-datinstr} >= Date(DateAdd("m", -1, Date(Year(CurrentDate), Month(CurrentDate), 1)))
and
{debt.dt-datinstr} < Date(Year(CurrentDate), Month(CurrentDate), 1)
)

but no joy

Thanks in advance

 

[Madawc]

In Crystal 8.5, you could create a formla field, @PastMonth, one month behind the current date
DateAdd(&quot;m&quot;, -1, CurrentDate)

Then compair this to your value:
{debt.dt-datinstr} >= @PastMonth

You could put this test in your selection criteria, so that the unwanted records are ignored.

Note that Crystal commands are smart enough to subtract whole months or years without the complications necessary in COBOL etc.

Madawc Williams
East Anglia, Great Britain