Converting iDate to Text 1

[dgillz]

I need an expression to convert a date such as today as text, and concatenate it with a sring. For example, I want "COMM: " and today's date in a MMDDYY format:

"COMM: 080907"

I tried an expression of "COMM: "+text(month(now()),"00")

Which I could logically extend to get the day and year pieces of the date, but the text function is not recognized. What is the best way to do this?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Lokoono]

This always works for me. I'm using Datefield as the name of the field that you're updating.

"Comm: " & Format([Datefield],"mm") & Format([Datefield],"dd") & Format([Datefield],"yy")


Hope it helps!

 

[dgillz]

Many thanks!

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[PHV]

Why not simply this ?
"Comm: " & Format([Datefield],"mmddyy")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886