Solved: Re: Date problem - Qlik Community

Report Inappropriate Content · ‎2014-03-25

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

PrashantSangle · ‎2014-03-25

Hi,

Use Date#() and Date()

Like

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

jsingh71 · ‎2014-03-25

Use This

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

--Jai

PrashantSangle · ‎2014-03-25

Hi,

Use Date#() and Date()

Like

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

2908nmadao · ‎2015-01-20

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.