Crystal Reports Day of the Week formula

Tips and Tricks
Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks

Topic: Day of the Week formula

Author	Message
Kathleen Newbie Joined: 31 Dec 2007 Location: United States Online Status: Offline Posts: 17	Topic: Day of the Week formula Posted: 09 Jun 2009 at 12:00pm
	I am trying to use the day of the week function to get a date to be represented as only the day of the week it occurred on. Meaning, {mederror.errordate} equals 06/09/09 I would like the formula to print "TUESDAY" I cannot make this work, I'm not sure if our dates aren't set up as "dates" or what, can someone help me out with this? Thanks in advance
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 09 Jun 2009 at 2:29pm
	WeekdayName(Weekday({mederror.errordate})) or if that is not a date field try WeekdayName(Weekday(cdate({mederror.errordate})))
	IP Logged

Kathleen Newbie Joined: 31 Dec 2007 Location: United States Online Status: Offline Posts: 17	Posted: 10 Jun 2009 at 9:09am
	I have now tried WEEKDAYNAME(Weekday({mederror.errordate}))) and received the error stating that a date must be here (where the {} field is. I have also tried WEEKDAYNAME(Weekday(cdate({mederror.errordate}))) and I receive bad format or string name. Are there any other suggestions? I guess this may take using two different formulas - first putting the date into a proper date format (I don't know how to do that) and then moving that new created field into one of the formulas above?? Does that sound doable?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 10 Jun 2009 at 9:42am
	couple of questions to tease this out. 1. In your field explorer, what data type is listed next to the mederror.errordate field? 2. Can you post some sample data that is actually from the field ... especially if there is ever instances that use an alpha character. Edited by DBlank - 10 Jun 2009 at 9:42am
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 15 Jun 2009 at 7:10am
	Hi You can try this in your formula to test what records don't have the date format which is expected by cdate function.... If IsDate({mederror.errordate}) Then WEEKDAYNAME(Weekday(cdate({mederror.errordate}))) else currentdate cdate is bit picky in the format it accepts the date... cheers Rahul P.S. Different checks you can include in the formula..... IF IsNull({mederror.errordate}) or Trim({mederror.errordate}) = "" totext({mederror.errordate},'dd/MM/yyyy') Edited by rahulwalawalkar - 15 Jun 2009 at 7:13am
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.