Formatting a date Field

[RachelK]

I have a date field that I am trying to put into date format. My problem is it keeps formatting the field into m/d/yy hh:mm:ss:am or pm if the date has a two digit month or day it will format mm/dd/yy etc so when I am asking to count the 2 character it could month or day so I would like to hard code this to say:--

Format {@PEPREV.DATE_APPLIED} to ddmmyy

 

[dgillz]

Formatting is not done via formulas in Crystal Reports (except for conditional formatting).

Right click on the field in question, select format, and about 20 different date formats will be available (assumming your field is a date field). If what you are looking for is not present in the defaults list, click on "cusomtize" and make sure your month and day formats are "03" and "01" instead of "3" and "1". Do whatever you would like in termd of displaying the time and you should be fine. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com