Date Format Issue

[#1]

Hi Community,

I have a small doubt about Date Format

I am having Field with name Start Date and it is in Date in format of  '2011/01/15 00:00:00'

I want to convert this in to MM/DD/YYYY Format I have used Date(floor([Start Date])) and also

Date([Start Date],'MM/DD/YYYY') But it showing null value . It should be Like 01/15/2011

Please Help me with this Issue

Thank you,

Swarup

[trdandamudi]

May be like this...

Date(Floor([Start Date]),'MM/DD/YYYY')

[sunny_talwar]

May be this:

Date(Floor(Date#(DateField, 'YYYY/MM/DD hh:mm:ss')), 'MM/DD/YYYY) as DateField

or

Date(Floor(Date#(Left(DateField, 10), 'YYYY/MM/DD')), 'MM/DD/YYYY) as DateField