Removing time stamp from date

[#1]

Hi ,

How to remove time stamp from Date.

PFA

[vinieme12]

1)if your field is actually a timestamp then use below

Date(Floor(YourField)) as DATEField

1)if your field is in text format

DATE(timestamp#(YourField,'MM/DD/YYYY h:mm:ss TT')) as DATEField

replace "MM/DD/YYYY h:mm:ss TT" with your actual format of timestamp.

[MarcoWedel]

Hi,

one solution might be to use the DayName-function:

LOAD *,
    DayName(DateTime) as Date
INLINE [
    DateTime
      17/03/2013 22:30:00
        17/02/2013 12:30:00
        15/03/2011 22:30:00
        17/06/2012 06:30:00
        17/06/2012 22:30:00
        17/02/2011 22:30:00
        17/03/2014 22:30:00
        14/03/2014 22:30:00
];

hope this helps

regards

Marco

[trdandamudi]

One more way is as below:

LOAD *, 

    Date(Floor(DateTime)) as Date

INLINE [ 

    DateTime 

        1/03/2013 21:45:00 

        10/02/2013 14:30:00 

        12/03/2011 22:30:00 

        12/06/2012 05:30:00 

        18/06/2012 20:30:00 

        18/02/2011 19:30:00 

        18/03/2014 20:30:00 

        19/03/2014 21:30:00 

]; 

[qlikcook]

Remember to mark a solution