Format date to 2-digit year (M/d/yy)

[pb100]

Thought I would post this tip as I figured out the answer by trying different options after reading through several posts. I could not find a straightforward answer so hopefully putting it here will help someone else.

I use CRXI and SQL 2005 and had a report with a text field description of several different strings concatenated together. The date was showing up in that string with a 4-digit year and my customer wanted only 2 digits. Here's how I solved it:

{stringA} & totext(date({datefield}), "M/d/yy") & {stringB}

The key was to put the M as an uppercase M. Works great now!

 

[IdoMillet]

Yes, a lowercase 'm' returns minutes - uppercase 'M' returns the month.

Watch out for nulls when concatenating strings...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Or you can drop all 3 items into a text box, then right click the date portion and format it however you'd like.

-k