Solved: Re: Date from Excel - Qlik Community

Report Inappropriate Content · ‎2014-09-30

Hello,

I have a excel sheet with lots of data - all data have a date collumn "yyyy-mm-dd".

When i import this collumn to Qlikview i get wierd formation. I only get a number string like "41814".

So how can i do to translate this in to its real value "2014-07-26"?

Thanks!

//Erik

ashfaq_haseeb · ‎2014-09-30

Hi,

Try like this

Date(YourDateFiled,'YYYY-MM-DD') as Date.

Regards

ASHFAQ

View solution in original post

ashfaq_haseeb · ‎2014-09-30

Hi,

Try like this

Date(YourDateFiled,'YYYY-MM-DD') as Date.

Regards

ASHFAQ

PrashantSangle · ‎2014-09-30

Hi,

Go to Number tab->Number Format Setting->Select date format. mention format as per requirement.

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 🙂

sorrakis01 · ‎2014-09-30

Hi Erik,

The answer of Ashfaq it's right.

Report Inappropriate Content · ‎2014-09-30

Thanks mate!

ashfaq_haseeb · ‎2014-09-30

Welcome

Regards

ASHFAQ