Formatting for display a date pulled from a database

[scaiferw]

I have dates stored in an MS-Access a database as data/time values.

I have found lots of material on how to format the current date for presentation, but I want to have the date from the database ($startdate) to show as "Jun-01" in one place and "June 1st, 2005" in another place.

Can anyone help me? Surely this isn't unusual - the page I'm inutting this message on uses a formatted date from a database!

Thanks in advance,

Rob

[fozerator]

Could you elaborate a little bit? I'm tempted to say use two variables and display based on a conditional... But I know that's not the answer you want :)

-James