date parameter for last day of the month

[cmyoung]

Hey all,

I am using crystal reports 8 and was wondering if there is some way I can create a date parameter that only asks for the month and year and automatically selects the last day of the selected month.

I was thinking about just entering values, but would I have to go 1-12 and something like 2000-20XX? Seems like a obsolete method to achieve the values.

If there is not an easy I know how to make a formula to auto correct a date that isn't the last date, but I just wanna make the parameter a little cleaner for what the user should be selecting, so they realize it should be the last day of the month.

Thanks!

 

[SkipVought]

Hi,

The Last day of Year, Month...

LastDate = DateSerial(Year,Month+1,0)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cmyoung]

I know the formula to achieve the last day of the month but I was just wondering if there is a parameter option so that the user only selects the month/date from a date serial.

If not I have other ways to solve this, so if you are replying this you don't really need to write out all the code unless you want to. I am just wondering.

Thanks though skip.

 

[lbass]

You could just ask them to enter any date in the month they want to and then convert their entry to the last day of the month.

I have also set up alerts so that if someone uses an end date other than the last day of the month, they are told to rerun the report and to use the corrected date (which I supply in the alert).

-LB