Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

alkesh_sharma
Not applicable

Creating Date field from two separate fields for Year and Month

Hello,

I have two separate fields for Year and Month.

can I create a date field from it?? Days I can take random.

Please help....

6 Replies
Not applicable

Re: Creating Date field from two separate fields for Year and Month

You can use Date(Date#(Year&MONTH,'YYYYMM')). it'll give the start date for that month.

alkesh_sharma
Not applicable

Re: Creating Date field from two separate fields for Year and Month

Hello Krupasagar,

Its not working...is there any other option??

shivaji123
Not applicable

Re: Creating Date field from two separate fields for Year and Month

Hi

insert dates

1,

2,

.

.

.

.

31,

Not applicable

Re: Creating Date field from two separate fields for Year and Month

Hi Sharma, Try with MakeDate function like below:

     MakeDate(YEARFIELD, MONTH) AS DATEFIELD

If you ignore day parameter, it takes 1st of month.

tresesco
Not applicable

Re: Creating Date field from two separate fields for Year and Month

MakeDate(Year,Month,1) as Date

alkesh_sharma
Not applicable

Re: Creating Date field from two separate fields for Year and Month

Nope, still not working...