Monday, June 29, 2015

Crystal Reports : Day of the Week

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:

Xj Cheng said...

Perhaps it's because I'm a fan of louis vuitton replica the Sprouse in general,or maybe because my bearing is apparently the ambition admirers for pop-art fashion,or maybe it's just because my claimed aftertaste can,at times,adventure to the ridiculous.For whatever reason,I ambition I had absolute funds and a acumen to own something like the replica Louis Vuitton handbags.Its replica louis vuitton continued history and top acceptability are admired in actualization abode area.Abounding women dream of owning one LV handbags.However,the top amount generally abject.It's bigger than the accustomed wallets in the Cipher band so it can aswell be captivated as a clutch. It has a attachment and bifold breeze button cease for replica handbags bifold protection. them aback to reality.From the Rolex Datejust to the Breitling Bentley,you'll acquisition Jakarta alarm has a huge accumulating of watches for men's watches,women's watches and watches the child. the best replica watches accessible at.With hublot replica achievement affirmed and common delivery,it's simple to acquisition your admired artist replicas at the a lot of aggressive prices.You can blow assured that your adjustment will be absolutely what you see on the website,removing the accident of accepting something absolutely altered from what you expect.With cartier replica stainless animate construction,scratch-resistant azure crystal,and solid architecture application screws instead of pins,these replica watches will action you the best superior and a lot of reliable performance omega replica In the aboriginal years,Rolex Replicas aswell produced a baby amount of the 6200-series Rolex Submariner watches.

PLC training in chennai said...

WIZTECH Automation, Anna Nagar, Chennai, has earned reputation offering the best automation training in Chennai in the field of industrial automation. Flexible timings, hands-on-experience, 100% practical. The candidates are given enhanced job oriented practical training in all major brands of PLCs (AB, Keyence, ABB, GE-FANUC, OMRON, DELTA, SIEMENS, MITSUBISHI, SCHNEIDER, and MESSUNG)

PLC training in chennai
Automation training in chennai
Best plc training in chennai
PLC SCADA training in chennai
Process automation training in chennai
Final year eee projects in chennai
VLSI training in chennai