Solved: Re: Create Date - Qlik Community

Report Inappropriate Content · ‎2015-05-14

Hi All

I have a Month field containing values Jan to Dec.

How can I create a dummy date field using the Month field I already have?

amit_saini · ‎2015-05-14

Hi,

Like this:

View solution in original post

Anonymous · ‎2015-05-14

This should work:

=date(date#(2015 & "MonthField" & 01, 'YYYYMMMDD'))

satishqlik · ‎2015-05-14

Could you attach the sample data.

PrashantSangle · ‎2015-05-14

Hi,

Use makeDate()

makeDate(2015,MonthField,1)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

amit_saini · ‎2015-05-14

Hi,

Like this:

Report Inappropriate Content · ‎2015-05-14

Thanks a lot!

mohammadkhatimi · ‎2015-05-14

MakeDate(num(financialyear),num(wildmatch([month],'Jan*','Feb*','Mar*','Apr*','May*','Jun*','Jul*','Aug*','Sep*','Oct*','Nov*','Dec*')),1)

Try the above logic...

Create Date

Related Topics