Month and Year combined to a Date

[#1]

Hi all,

I have a problem.

I have a order_table, there are 2 columns one for months and one for years in the format like this:

month	year
1	13
1	13
2	13
3	14

I want to combine that columns to one, called 'order_date' but qlikview do not recognice that this numbers are dates.

But I need this, to combine it with my master_calendar.

Any ideas?

[alexandros17]

Use

Makedate(Year+2000, month, 1)

to build a date starting from year and month ...

[#3]

Perfect many thanks