Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My below expression is not working fine. Please provide your valuable suggestions.
Date(Date#("Accounting Year Month",'YYYYMM'),'MMM-YYYY') AS "Accounting Year Month"
Thanks in Advance,
Regards,
Manu
Hi! It could be helpful to know where you start (Accounting Year Month format) and where you'd like to arrive (the format of the result you want) and why you are using two different date function.
For now, this could be helpful:
https://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Scripting/FormattingFunctions/Date.htm
Very probably had your field "Accounting Year Month" another format then you have applied, then in general this worked:
- Marcus