Date format...

R

Rick

I have a query that I need to change the date format on so that when it reads
into a report chart with few characters.. the current is 07/29/06 I would
like it to read 7/29 yet know logically in the kquery that it's 2006 without
2006 or 06 being seen. Any help would be appreciated..

Thanks
 
R

Rick Brandt

Rick said:
I have a query that I need to change the date format on so that when it reads
into a report chart with few characters.. the current is 07/29/06 I would
like it to read 7/29 yet know logically in the kquery that it's 2006 without
2006 or 06 being seen. Any help would be appreciated..
Click to expand...

You can use...

Format(YourField, "m/dd")

....but that will be output as text (no longer a date) which will affect sorting
(if that matters).
 
Top