topic Re: Removing time stamp from date in QlikView

Removing time stamp from date

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

How to remove time stamp from Date.

PFA

Re: Removing time stamp from date

vinieme12 — Sun, 12 Feb 2017 15:26:38 GMT

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.

Re: Removing time stamp from date

MarcoWedel — Sun, 12 Feb 2017 21:42:32 GMT

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

Re: Removing time stamp from date

trdandamudi — Mon, 13 Feb 2017 00:00:26 GMT

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

];

Re: Removing time stamp from date

qlikcook — Fri, 10 Sep 2021 11:58:57 GMT

Remember to mark a solution