Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Breezy
Creator II
Creator II

Changing strings to yyyy dates?

I loaded my Excel sheet which included a column of years (such as 2015, 2009, 2004, etc.). When my Excel file was loaded into Qlik the dates appear as strings, 42005, 39904, etc. I would like to turn them back into years. I think I need to define that column as yyyy. However, I have not actually used the Data Load Editor before. I just have it do everything automatically. Would I click 'unlock' first?

Below is part of the script in the LOAD section. I want to change [COMPL_PER_BEGIN_YEAR] to show just yyyy. I would like to keep the [COMPL_PER_BEGIN_DATE] as it is, however, which is 1/1/2015, 4/1/2009, etc.

[COMPL_PER_BEGIN_YEAR] AS [COMPL_PER_BEGIN_YEAR],

Date([COMPL_PER_BEGIN_DATE] ) AS [COMPL_PER_BEGIN_DATE]

Your assistance is appreciated. Thank you.

10 Replies
Breezy
Creator II
Creator II
Author

Thank you for your assistance, Sunny