Date format...

[Guest]

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

 

[Rick Brandt]

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..

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).