Monday, December 1, 2014

Crystal Reports : Deriving the Day-of-Week from a Date Value

A client asked: I would like to display the day of the week on the detail line along with the date. How do I do this?


Using the example of CREATEON in Goldmine Contact1, you would do the following:

Create a formula using the DayOfWeek function called DayPosition as follows. This will create the numerical position of the date (e.g. 1=Sun, 2=Mon, etc)

DayOfWeek ({Contact1.CREATEON})

Then create a formula called DayName. This will add the name to the report (Mon, Tue, Wed). Use the function WeekDayName and add the DayPosition as the function detail

WeekdayName ({@DatePosition})

Drag the DayName formula to the detail row next to the CREATEON date. It will list the weekday name of the CREATEON date.

2 comments:

Anonymous said...

The actual dior replica rating pretty much about this because the replica dior handbags these people are constructed with isn't just sleek as well as nicely processed however it's also the long lasting range. The quantity of comfort and ease it offers is excellent as well as no matter dimension from the individual, it may match perfectly. This can be a fairly easy hublot replica which makes all the whole procedure handy. High quality associated with materials is actually 1 function which makes a great belt. You need to make sure to help to make putting on this kind of fake hermes bags enjoyable. Because whenever this began becoming folded away, lots of manufacturers happen to be created as well as folded to the marketplace. The same as every other fake prada bags available for sale, the actual belt is really a achievement popular developments because of its special images as well as amazing design.

swiss replica watches said...

Few a quite a while later regarding we were definitely holding conducting their part within the Fantastic Conflict by merely giving any 'Soldier's Watch' has been created with the distinct variations . grill that will shield replica Gucci watches any facial skin holiday retained the true Movado observe style. Even though there exists a war on my organization is not saying you cannot look fine! Later regarding within fake Zenith watches UK 1927 these developed a good self-winding account with a bank watch the fact that employed a good forward wondering system in an effort to wind circulate this on every occasion it had been slid room and outer walls its condition. In 1947 Nathan George Horwitt long been being engaged for a artist and likewise created the best Public Benefit fake IWC watches from (the way it is right now recognize! )#). It was in line with the style notion Swiss Replica Watches UK associated with a sundial, Replica Breitling watches with it is actually signature drab dial and even one precious metal dept for transportation sign with a dozen o'clock.