Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
lthurman
New Contributor III

Re: Formatting a date using the Expression Editor

Ok, so after adding the aliases to my load script, I tried this:

=Date(Date#(Num#(Text), 'YYYYMM'), 'MM YYYY')

and

=Date(Date#(Num), 'YYYYMM'), 'MM YYYY')

Same result.

Thanks for helping with this, by the way.

Highlighted

Re: Formatting a date using the Expression Editor

I was wondering if you can share a list box object for the two new fields that you created on my request....

Highlighted
lthurman
New Contributor III

Re: Formatting a date using the Expression Editor

Sorry, I forgot to follow up, but we finally figured it out. It seems that our original formula was trying to create a date from a string. We should have been trying to create a date from a number. The correct formula to create our MMM/YYYY date is:

=date(makedate(num(left(BillDate,4)),num(right(BillDate,2))),'MMM YYYY') where Billdate is a sring of the format, YYYY/MM.

Thanks for all your help.

View solution in original post