Date Formula

[BROWNIE56]

How would I make the following ToText work corrctly

ToText({EMPLOYER.emp_rep_start_date}), "DD MM YYYY&quot

I want my date to print like: 03/28/02

Thank you

 

[dgillz]

This is a format issue not a formula issue. Place the date field itself on the report, then, in the design window, right click the date field and select format. There are several choices on data formatting and one will suit your needs. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Guest_imported]

The date field will be placed in a formula such as:

"Rep. Name: + ToText({EMPLOYER.emp_rep_start_date}), "DD MM YYYY&quot

This information has to be in a sub-report and I want to have the info as aligned as possible. I can get the info to print, but the date comes out as a 1 digit day instead of a two digit day, that is my compan'y standards.

03/02/2002

 

[rogar]

Use this formula:
ToText({EMPLOYER.emp_rep_start_date}, "dd/MM/yyyy&quot
Note that there should NOT be a &quot" after the date field!

 

[Guest_imported]

Thank you,

It worked

ToText({EMPLOYER.emp_rep_start_date}, "dd/MM/yyyy&quot
Note that there should NOT be a &quot" after the date field!