Qlik Community

Qlik Sense App Development

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

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.

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