simple date formula

[Jacob438]

I have a date parameter that the user inputs

If this date parameter is after today (in the future), I want a formula to return todays date, otherwise, I want to return the date entered.

I will be using this on my report because if the user inputs some stupid date in the future, I don't want that to show up in the header, I want that label to show todays date in the header instead.

Oh, and I want to know how to do this in Crystal Syntax, I can do it in VB syntax, but I need crystal... don't ask

thanks,

Jacob

 

[Jacob438]

nevermind... I think I just got it...woohoo!

here's what I got, in case anybody else has this problem...

if DateDiff(&quot;d&quot;,Date(Year({?End Date}),Month({?End Date}),Day({?End Date})),CurrentDate) < 0 then
CurrentDate
else
Date(Year({?End Date}),Month({?End Date}),Day({?End Date}))


Thanks anyways!

Jacob438

 

[synapsevampire]

Or:

if {?End Date} > currentdate then
CurrentDate
else
{?End Date}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Jacob438]

haha, cool, yeah, much simpler, thanks,

Jacob438