Concatenate Question
Hi Heather
why don't you format the field to show the Name of the Day as well?
Custom format would be: dddd mmmm d, yyyy
or (if you want 3 letter months) dddd mmm d, yyyy
i hope i understood you right
Carlo
On Jan 16, 1:37*pm, Learningfast
wrote:
HI
My data is two values
Day * * * * * * Monday
Date * * * * * * * * *May 8, 2008
The new result it
Concatenate #1 *Monday34567 (the result has no space and there is a number
instead of the date).
Question: *How do I program a space between the two and
Question: *How do I format the date as text so it looks like a date?
Thanks!
Heather
|