topic Re: Date Problem in QlikView

Date Problem

pgalvezt — Thu, 11 Aug 2016 14:24:01 GMT

Hello,

I have two information sources (xls and csv).

I need to concatenate both tables. (xls come in format DD-MM-YYYY. csv in DD/MM/YYYY

I tried this but doesn't work:

Date(Date#(Left(FECHAYHORA, 10), 'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Id_date

FECHAYHORA is in csv...

Thanks!

Re: Date Problem

Thu, 11 Aug 2016 14:26:25 GMT

Date(Date#(FECHAYHORA, 'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Id_date

Re: Date Problem

sunny_talwar — Thu, 11 Aug 2016 14:34:18 GMT

or this:

Date(Date#(Left(FECHAYHORA, 10), 'DD/MM/YYYY'),'DD-MM-YYYY') as Id_date

Re: Date Problem

maxgro — Thu, 11 Aug 2016 14:38:03 GMT

if you peek the first (with the left function) 10 char from FECHAYHORA

Date(Date#(Left(FECHAYHORA, 10), 'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Id_date

I think you should interpret (Date#) the first 10 char

Date(Date#(Left(FECHAYHORA, 10), 'DD/MM/YYYY'),'DD-MM-YYYY') as Id_date

or don't use left

Date(Date#(FECHAYHORA, 'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Id_date

Re: Date Problem

pgalvezt — Thu, 11 Aug 2016 14:55:28 GMT

Hello,

Thank you for your reply. I tried all posibilities I think. But Doesn't work. I put An Example...

Thanks!

Re: Date Problem

sunny_talwar — Thu, 11 Aug 2016 15:01:18 GMT

May be this:

Date(Floor([FECHA Y HORA]), 'DD-MM-YYYY') as Id_date

Re: Date Problem

sunny_talwar — Thu, 11 Aug 2016 15:02:48 GMT

There is no data within FECHAYHORA

Re: Date Problem

ecolomer — Thu, 11 Aug 2016 15:03:42 GMT

Try this:

makedate(mid(FECHAYHORA, 7, 4), mid(FECHAYHORA, 4,2), left(FECHAYHORA, 2), 'DD/MM/YYYY') as Fecha_New

Re: Date Problem

pgalvezt — Thu, 11 Aug 2016 15:08:42 GMT

Thank you Sunny!

Re: Date Problem

pgalvezt — Thu, 11 Aug 2016 20:11:01 GMT

Hi, Sunny, I just i realized that :

Date(Floor([FECHA Y HORA]), 'DD-MM-YYYY') as Id_date .... delete the format hh:mm:ss... Actually that information i need it because I do Intervales of time in my chart. How can I show the time too, with your formula?

for example 01-01-2016 00:00:00

Before was: 01-01-2016 01:35:25

Thanks!

Re: Date Problem

sunny_talwar — Thu, 11 Aug 2016 20:12:49 GMT

Why don't you use [FECHA Y HORA] to create intervals? and use Id_date as just date?

Re: Date Problem

pgalvezt — Thu, 11 Aug 2016 20:52:03 GMT

Right...

I was using for all my calculations (Intervals) Id_date...

I can see now hour minute etc,

Thanks!