topic Re: Date in QlikView

Date

upaliwije — Mon, 11 Nov 2013 06:23:36 GMT

In my I have two fields Month & Year. I want to extract Date using Month and year fields. Date may be last date of the month

Year Month Required DAte

2012 01 31-JAN-2012

2012 12 31-DEC-2012

Is there a way to do this please help me.

Sokkorn — Mon, 11 Nov 2013 06:34:02 GMT

Hi Upali,

Maybe you can try this:

[Data]:

Load

[Year],

[Month],

Date(MonthEnd(Date#([Year] &'-'& [Month],'YYYY-MM')),'dd-MMM-yyyy') AS [NewDate],

...

From...

Regards,

Sokkorn

Gysbert_Wassenaar — Mon, 11 Nov 2013 09:39:35 GMT

Or like this:

Table1:

Load

date(monthend(makedate(Year,Month)),'DD-MMM-YYYY') as NewDate

From ....