Wildcards in date

[Shanna]

Hi all,

Is there a way of incoprporating a wildcard into a date? For example, using the datre formula (where the asterix * is the wildcard) :

If month (start) = Date (year(CurrentDate),2,*)

I need to calculate the current year, month 2, but any day within that month.

Does anyone have a suggestion?

Many thanks,
Shanna

 

[mbarron]

I would use:
(year({@date})=year(CurrentDate) and
month({@date})=2) Mike

 

[Ngolem]

"If month (start) = Date (year(CurrentDate),2,*)

I need to calculate the current year, month 2, but any day within that month."

Sorry but this does not make a lot of sense to me...

Month(start) is a function giving you the month of a date/dateTime variable called "start".

I don't see how you can compare it to a complete date...wildcard or no wildcard.

I think you need to give us more details about what you are trying to do.

 

[kenhamady]

R&R Report writer had wild cards for date literals, but CR doesn't. Mbarron's approach is correct, where you simply compare the other 2 values of the date, and ignore the third (wild) value. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com