Date Issue

[#1]

Hi Community,

I have small issue in Date format

I am having a field with name Start Date. It is in this format 2011/01/15 00:00:00

I Need this field should be in MM/DD/YYYY Format. I have used Date(floor([Start Date])) it showing Null value and also used

Date([Start Date],'MM/DD/YYYY') I am facing same null value here also. could some can please help me in resolving Issue

Thank you,

Swarup

[trdandamudi]

May be like this...

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

[sunny_talwar]

I believe it is the same issue as here:

Date Format Issue