topic Re: Create Date Field Using Numeric Year and Alpha Month Name in QlikView

Create Date Field Using Numeric Year and Alpha Month Name

Anonymous — Mon, 29 Feb 2016 20:28:13 GMT

Inputs

Month: Apr

Year: 2015

Desired output: 201504

Current syntax:

Num(Year & num(month(date#(Month,'MMM'))), '000000') as [Fiscal Period]

Current output: 020154

I'm very close but I cant seem to figure out where I am going wrong.

Any help is appreciated.

- dave

sunny_talwar — Mon, 29 Feb 2016 20:30:50 GMT

Try this:

Date(MakeDate(Year, Month(Date#(Month, 'MMM')), 1), 'YYYYMM') as [Fiscal Period]

Date(Date#(Year & '-' & Month, 'YYYY-MMM'), 'YYYYMM') as [Fiscal Period]

swuehl — Mon, 29 Feb 2016 20:31:47 GMT

Try

Year & num(month(date#(Month,'MMM')), '00') as [Fiscal Period]

Date( Date#( Year & Month,'YYYYMMM'), 'YYYYMM') as [Fiscal Period]

note that the underlying numeric value is differenct in the second approach (it's the monthstart date value)

Anonymous — Mon, 29 Feb 2016 20:32:36 GMT

Amazing. Thank you per usual.

sunny_talwar — Mon, 29 Feb 2016 20:33:47 GMT

Not a problem

maxgro — Mon, 29 Feb 2016 20:35:08 GMT

try

Date(Date#(Year & Month, 'YYYYMMM'), 'YYYYMM') as .......