date formula 1

[SamLN]

Hi all tek heads
I need to report on the day of the week that a birthday will fall in the current year.
something like
birthday is 18/04/1971 which becomes 18/04/2013 therefore day displayed in the report is THURSDAY. if I ran the report next year, the day would be FRIDAY (if the 18/4/2014 is a Friday?).

thanks
Sam

 

[pmax9999]

Try:

WeekdayName(WeekDay(Date(Year(CurrentDate), Month({Data.BirthDate}), Day({Data.BirthDate}))))

I don't have access to Crystal at the moment to verify the syntax so apologies in advance if it isn't quite correct. Replace {Data.BirthDate} with the actual field from your database.

Cheers
Pete

 

[SamLN]

Thanks Pete, that was absolutely perfect!!

 

[pmax9999]

Glad it worked.

Pete

 

[kenhamady]

What if you just right-click the field, go to Format Field and click "Customize". Then on the DATE tab turn off everything but the name of the day of the week.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/