Am trying to put in a formula the p

[patty1]

Am trying to put in a formula the prior months date. In other words the user puts in the date parameters then in the report are the totals for that date parameter and the previous month's totals but I can't get the formula right to say what the previous month is.

Here is the formula for the month the user puts in:

totext({?StartDate},"MM/dd/yy&quot + " - " + totext({?EndDate},"MM/dd/yy&quot


I know I have to put -1 somewhere but have tried all ways but to no avail. Anyone...?

 

[synapsevampire]

Try:

totext(dateadd("m",-1,{?start date}),"MM/dd/yy&quot + " - " + totext(dateadd("m",-1,{?end date}),"MM/dd/yy&quot

-k

 

[patty1]

Unfortunately am using Crystal 7.1 and dateadd does not work - any alternative? Tried doing:

totext(Date("m",-1,{?StartDate}),"MM/dd/yy&quot + " - " + totext(date("m",-1,{?EndDate}),"MM/dd/yy&quot

but I get message of need number here

 

[dgillz]

Download the dateadd() function from the crystal decisions website.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[patty1]

Am now getting "a datetime is needed here" (cursor is after the -1,. The field is a datetime field but the "MM/dd/yy" just gave me the date which is what I need.

totext(dateadd("m",-1,{?StartDate}),"MM/dd/yy&quot + " - " + totext(dateadd("m",-1,{?EndDate}),"MM/dd/yy&quot

Thanks for the tip about the dateadd!

 

[dgillz]

This means that your parameter field {?StartDate} is not a date or date/time datatype. Edit your parameter field and change the data type to date.


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[patty1]

Okay - the formula works but the parameter is showing the time as well as the date- my users only want to see the date. This is running off of a stored procedure - should I be doing some sort of conversion in there to go from datetime to date or can I do this in the formula?