Discussion board where members can get started with QlikView.
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.
Go to Solution.
Your second expression should work. If not, try to share a sample showing the issue.
View solution in original post
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 '-'.
May be try this
Date(Date#([Fin Month Name F] & '-' & [Fin Year F], 'MMM-YYYY'), 'MMM-YYYY')