topic Re: Remove time from a date field in QlikView

Remove time from a date field

Anonymous — Tue, 30 Sep 2014 16:06:14 GMT

Good Morning friends.

I have a qvd file.

This field is as :

06/11/2013 08:10:28 p.m. --------> 06/11/2013

Remove date time field.

I generate the sentence "FLOOR"

DATE(FLOOR(ProductosDim),'DD-MMM-YY') AS KEY2,

¿that's right?

Date:06/11/2013

Hour:08:10:28 p.m

Please!!

thanks for the support!!

mjayachandran — Tue, 30 Sep 2014 17:23:26 GMT

Something like this might help u..

1. date(floor(timestamp#(ProductosDim,'M/D/YYYY h:mm:ss[.fff] TT')),'DD-MMM-YY') as date

2. time(frac (timestamp#(ProductosDim,'M/D/YYYY h:mm:ss[.fff] TT'))) as time

in your timestamp under time 08:10:28 p.m is a wrong format. We need to trim the '.' from P.M

so your expression becomes

=date(floor(timestamp#(replace('06/11/2013 08:10:28 p.m','.',''),'MM/DD/YYYY hh:mm:ss TT')),'DD-MMM-YY')

anbu1984 — Tue, 30 Sep 2014 17:35:52 GMT

Duplicate post

Tue, 30 Sep 2014 17:40:57 GMT

Hi,

Try something like below

=Date( Makedate(mid(value,7,4),Mid(value,4,2),mid(value,1,2) ) , 'DD/MM/YYYY')

hope it helps

Kiru