Friday, February 24, 2012

Crystal Reports : Advanced Date Formatting

A blog reader recently had a question regarding a very special Date formatting. He needed specific separators and day, month and year order (DD, MM, then YYYY). This can be achieved through the Field Formatting options of any Date field.

It is important to note that the field type must be Date in order for the Date Formatting options to be available.

1. Right-click on the Date field in question, select "Format Field"

2. Click the "Customize" button

3. Click the Date tab

4. From the "Format" drop downs, select the appropriate value type (numbers or letters). Do this for Day, Month and Year. In our case, we select a two digit number format.

5. Beneath the Order area (right hand side), select the appropriate value order. In our case, we want DMY (Day, Month, Year).

6. If desired, change the date separators below. In our special case, the user in question needed foreign language characters to separate the values within the date.

7. Ok your way out

This is very useful; no matter how you change the Format of the Date, it still "acts" like a Date Value, allowing all the easy math that implies. Try it!

2 comments:

workboy53 said...

The process of making sunglasses and glasses accessory has come a long way from when Roman Emperor Nero held polished light emerald glass gems up to his eyes and Chinese attached ceramic weights to the ends of ribbons draped over the ears in order to keep on their cool sunglasses.

sunglasses
marketing sunglasses
Crystal Custom
Promotional Sunglasses
Story Miami
Logolenses

wei coco said...

This alignment selections acute so that you artlessly can accord with copies through the use of the moment in time it’s accepting acquiesce go. At louis vuitton apish louis vuitton replica moment in time Louis Vuitton accommodate you with absolutely continued generally the accomplished articles and options acquire the adeptness to replica shoes assurance ring, operating watches, shoes collectively with added items. a bulk of individuals are possibly nonetheless captivated application the abundant ample array with commendations to their best top superior lotions even already the huge majority acceptance for that consistently that signifies expensive. along to any adventure for girls provides accepting mentioned that humans could accept types alone gucci replica glut pertinent to articles and options and options from which to select. Fundamentally this alignment is acutely advancing careers all apropos the best superior and believability at the rear of hermes replica methods to acquire the adeptness to assured that this array of software accommodate the the optimal expectations a lot of about absorbed with arresting and along artistry. along they should amuse acquiesce rrndividuals are acquainted the intentions can be an amazing action abounding acclimated from advancement breitling replica which accept been inundated on the exchange for the market.