topic Re: Date problem in QlikView

Date problem

Tue, 25 Mar 2014 12:13:07 GMT

Hi,

I have an excel file with dates in it. The fieldname is 'Date' and the format is as follows: 30.09.13

Qlikview doesn't except it as a date. How do I get it to adjust it?

Thanks

Re: Date problem

jsingh71 — Tue, 25 Mar 2014 12:22:19 GMT

Use This

Date(Date#('30.09.13','DD.MM.YY'),'DD-MM-YY')

--Jai

Re: Date problem

PrashantSangle — Tue, 25 Mar 2014 12:22:45 GMT

Hi,

Use Date#() and Date()

Date(Date#(DateFieldName,'DD.MM.YY'),'DD-MM-YYYY') as NewDate

Regards,

Re: Date problem

2908nmadao — Tue, 20 Jan 2015 14:57:59 GMT

Hi Community,

I recently joined and I am amazed with the amout of information that can be found here !

I am trying to convert a table date field DD/MM/YYYY HH:MM:SS to a filed that will make easier for me to manipulate when creating Charts and Tables, etc.

My question is, can I make it directly in my initial script rather than in an object expeession, so that I will not have to amend it each time I insert a new object?

Thanks for your time!

Kind regards,

Nelson.