Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Your second expression should work. If not, try to share a sample showing the issue.
Your second expression should work. If not, try to share a sample showing the issue.
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
May be try this
Date(Date#([Fin Month Name F] & '-' & [Fin Year F], 'MMM-YYYY'), 'MMM-YYYY')