Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Removing time stamp from date

Hi ,

How to remove time stamp from Date.

PFA

4 Replies
vinieme12
Champion III
Champion III

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.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MarcoWedel

Hi,

one solution might be to use the DayName-function:

QlikCommunity_Thread_249573_Pic1.JPG

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
Master II
Master II

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
Contributor III
Contributor III

Remember to mark a solution