topic Re: Fiscal Date Formate in QlikView

Fiscal Date Formate

Hania — Mon, 17 Apr 2023 07:02:28 GMT

I am facing issue in formatting can you guys help me,

I want to format fiscal year ,

Fiscal Year in format as : 2011-2012

required Format : 2011-12

Looking forward to your response.

Mark_Little — Mon, 17 Apr 2023 07:10:35 GMT

In script use the following

SUBFIELD('[Fiscal Year]', '-',1)&'-'&RIGHT(SUBFIELD('[Fiscal Year]', '-',2),2) AS [Fiscal Year]

Hania — Mon, 17 Apr 2023 07:43:56 GMT

Thank you for your reply it gives me result but with data type of string and i want result with numeric data type.

BrunPierre — Mon, 17 Apr 2023 08:36:47 GMT

Slight addition to @Mark_Little 's suggestion.

DATE#(SUBFIELD([Fiscal Year], '-',1)&'-'&RIGHT(SUBFIELD([Fiscal Year], '-',2),2),'YYYY-YY') AS [Fiscal Year]