Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Converting text into date

Hi all,

 

I have the field Year and month ...i have concatenated the both and created the field  example :2019-09 

 

Now i want to convert this in date format and also i want to generate date as well...as it has no date values ,like 1,2,3 ,4//etc.

 

 

Can anyone help me in this.

Labels (1)
1 Reply
Anil_Babu_Samineni

Please generate the Calendar for your field, For now - Simplify using this

Date(Date#(FieldName, 'YYYY-MM'))

Or

=MakeDate(Year(Date#(FieldName, 'YYYY-MM')),Month(Date#('2019-09','YYYY-MM')))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)