Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator III
Creator III

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_...

marcus_sommer

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

- Marcus