topic Re: How to convert a Month, Year and day into a date in QlikView

How to convert a Month, Year and day into a date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

My script has three fields: A month, day and Year. What I would like to do is to convert it into one variable called Date.

Does anyone have an idea?

I have used "Date(day&'/'&Month&'/'&Year) as Date" and it is not working properly.

Thanks in advance.

Re: How to convert a Month, Year and day into a date

kaushiknsolanki — Mon, 07 Mar 2016 11:38:03 GMT

Hi Use,

Makedate(Year,Mont,Date) as Date

Re: How to convert a Month, Year and day into a date

MayilVahanan — Mon, 07 Mar 2016 11:38:39 GMT

Try like this

MakeDate(Year, Month, Day)

Re: How to convert a Month, Year and day into a date

sunny_talwar — Mon, 07 Mar 2016 11:38:42 GMT

Try the MakeDate() function

MakeDate(Year, Month, Day) as Date

UPDATE: In case Month is a text (Jan, Feb, Mar, .... etc), you can try this:

MakeDate(Year, Month(Date#(Month, 'MMM')), Day) as Date

Re: How to convert a Month, Year and day into a date

arulsettu — Mon, 07 Mar 2016 11:39:09 GMT

may be this

makedate(Year,month) as Date

Re: How to convert a Month, Year and day into a date

MayilVahanan — Mon, 07 Mar 2016 11:42:05 GMT

Suppose, if the Month is in Text, then try like this

MakeDate(Year, Month((Date#(Month, 'MMM'))), Day)

Re: How to convert a Month, Year and day into a date

avinashelite — Mon, 07 Mar 2016 11:43:39 GMT

As all suggested use the makedate() function

MakeDate(Year, Month, Date) .....you need to keep the order of the inputs ..that is anything placed as 1 argument will be taken as the Year ,,2nd as the month ....and 3 as the date ...

if you give only year than the month and date will be defaulted to 01 &01

Re: How to convert a Month, Year and day into a date

Anonymous — Mon, 07 Mar 2016 12:25:55 GMT

Thanks Sunny.

Script was giving 0 values because Month variable was in text format.

Now it is working well.