Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Single format? What does that mean? Just the date part and remove Time? May be this
Date(Floor([Closed time])) as [Closed date]
Hi,
Do the following:
Dates:
Load
Date(floor([Closed time]),'MM/DD/YYYY') as [Closed Time]
From [Whatever];
Single format means i assume only date,right?
Date(Floor([Closed time]),'M/D/YYYY') as SingleDateForm
Try
date(floor(Timestamp#([Closed time],'M/D/YYYY hh:mm')))