Qlik Community

Qlik Sense App Development

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

Not applicable

Formatting Date not working in Script

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

2 Replies
simotrab
Contributor II

Re: Formatting Date not working in Script

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

https://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Scripting/InterpretationFunctions/date_...

Re: Formatting Date not working in Script

Very probably had your field "Accounting Year Month" another format then you have applied, then in general this worked:

- Marcus