topic Re: Formatting Date not working in Script in App Development

Formatting Date not working in Script

Wed, 08 Jun 2016 06:20:28 GMT

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

Re: Formatting Date not working in Script

simotrab — Wed, 08 Jun 2016 07:52:12 GMT

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_hash.htm

Re: Formatting Date not working in Script

marcus_sommer — Wed, 08 Jun 2016 08:06:25 GMT

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

- Marcus