Hi Team

[Kohli]

I have a date field like below. i want convert the date in single format, can pls help me?

Closed time

6/13/2011 12:12

6/24/2011 13:10

6/2/2011 6:43

6/2/2011 9:16

6/2/2011 6:20

6/5/2011 5:59

6/2/2011 8:59

6/2/2011 9:00

6/2/2011 9:02

6/2/2011 9:16

6/5/2011 6:57

6/2/2011 9:16

6/29/2011 5:05

6/11/2011 7:09

6/1/2011 8:02

[sunny_talwar]

Single format? What does that mean? Just the date part and remove Time?  May be this

Date(Floor([Closed time])) as [Closed date]

[felipedl]

Hi,

Do the following:

Dates:
Load

     Date(floor([Closed time]),'MM/DD/YYYY') as [Closed Time]

From [Whatever];

[its_anandrjs]

Single format means i assume only date,right?

Date(Floor([Closed time]),'M/D/YYYY') as SingleDateForm

[shraddha_g]

Try

date(floor(Timestamp#([Closed time],'M/D/YYYY hh:mm')))