Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nkosinde13
Creator
Creator

Combining month and year

Good day community

I have month name e.g Jan, Feb etc.. and year e.g 2018,2019 etc and need to combine the two to make one date. I've tried a couple of expressions like below and none seem to work: 

Date(Date#([Fin Month Name F], 'MMM') & '-' & [Fin Year F], 'MMM-YYYY')

Date(MakeDate([Fin Year F], Month(Date#([Fin Month Name F], 'MMM'))),'MMM-YYYY')

Any help is greatly appreciated.

Thanks

Matlotlo

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Your second expression should work. If not, try to share a sample showing the issue.

View solution in original post

3 Replies
tresesco
MVP
MVP

Your second expression should work. If not, try to share a sample showing the issue.

nkosinde13
Creator
Creator
Author

Oh thank you. I see now where I was getting it wrong, just a silly error. It is actually working with the second expression, I've been selecting only a month on list boxes instead of both month and year, that's why it was giving me '-'. 

Thanks

Matlotlo

sunny_talwar

May be try this

Date(Date#([Fin Month Name F] & '-' & [Fin Year F], 'MMM-YYYY'), 'MMM-YYYY')