date formate

[balasundaram]

1-Jul-2014 to 7/1/2014

how to convert?

[Anonymous]

Try this

Date(Your_Date,'MM/DD/YYYY')

[MayilVahanan]

Hi

Try like this

Date(Date#('1-Jul-2014','D-MMM-YYYY'),'M/D/YYYY')  as DateField

or

Date(DateField,'M/D/YYYY') as DateField

[#4]

Mayil vahanan ramasamy is correct

[amit_saini]

Try this:

Date(Date_Field,'M/D/YYYY')

Thanks,

AS

[MK_QSL]

=Date(Date#('1-Jul-2014','D-MMM-YYYY'),'M/D/YYYY')

or

=Date(Date#('YourDateField','D-MMM-YYYY'),'M/D/YYYY')

[jagan]

Hi,

Try like this

Date(Date#('1-Jul-2014', 'D-MMM-YYYY'), 'M/D/YYYY')

Hope this helps you.

Regards,

Jagan.