Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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')))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful