Select (Extract(Month from MyDate) || '/' || Extract(Day from MyDate) || '/' ||
Extract(Year from MyDate)) as NewlyFormattedDate
From...

women_lover_best wrote:

> I need to format date and display as mm/dd/yyyy..in crystal
> reports...what we r doing is assiging data into a Datatable(.net)..and
> then setting it as source for report..but for date time is also
> showed..i want to suppress that..
> pls help
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>