Forget it. Forta already answered this one a while ago on HoF. (Get the FirstDayofMonth, use DateAdd to add that many days to Jan 1st of that year, then use DayofWeekAsString to get the day name)
Thanks anyways! Ray At 08:20 PM 1/7/2005, you wrote: >I figure this has already been done by some out there: > >I need to get the first day of the month as a string when passing in a date. > >So far, I see that #FirstDayofMonth(date)# will get me the ordinal day of >the year (0-366), but how does one extract the day as a string? > >THX, > >Ray > >============================================= >Ray Champagne - Senior Application Developer >CrystalVision Web Site Design and Internet Services >603.433.9559 >www.crystalvision.org >============================================= > >The information contained in this transmission >(including any attached files) is CONFIDENTIAL and is intended only for the >person(s) named above. If you received this transmission in error, >please delete it from your system and notify us immediately. If you >are not an intended recipient, please note that any use or dissemination >of the information contained in this transmission (including any >attached files) and the copying, printing, or retransmission of that >information is strictly prohibited. You can notify us by return email or by >phone at 603.433.9559. Thank you. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189709 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54