Thursday, February 27, 2014

Crystal Reports : Display the day of week from a date

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.

1 comment:

Xiao Nan said...

Studying a specific gucci replica level of endurance will mean you are able to build-up the garments and also components storage as time passes and also eventually you'll have replica chanel handbags variety close at hand (and stay the particular be jealous of of one's close friends). Remember to be able to aren't getting deceived simply by ingenious reproductions. Traditional look-alike artist bags are really pricey. If you'd like genuine and you also fake gucci are interested fresh you have to be ready to pay out as a result of that. There is certainly merely which has no some other fake chanel bags uk approach. Positive, you might help save several hundred or so the following and also in all honesty right now there, yet you might never acquire a traditional replica chanel uk to get a lower price regarding hundreds. Understand to consider the particular products about on the web market web sites cautiously. Obtain try to find modest information in which counterfeiters can not manage to be able to replicate. Here is the ultimate solution to chanel replica identify coming from originals and also reproductions.