Format Date

[dbero]

Hello:

I need to format dates to something like 'Mar 2009'. However, i then need the ability to sort as a date rather than as a string (Mar 2009, April 2009, May 2009, etc.) Any tips to do this?

thank you

 

[PWise]

format(datefield,"mmm yyyy")

 

[HarleyQuinn]

In addition you can then order by your unformatted date field to get the order you want.

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com