Make date

[paulwalker]

Hi,

I have Year and Month

Year        Month

2013          9

2013          8

2013          3

2013          4

How to make date ............

[Anonymous]

Paul

     date(date#([Year] & num( [Month] ,'00'),'YYYYMM'))

Best Regards,     Bill

[#3]

Please try with MakeDate function like below:

MakeDate(Year,Month) AS DATE_FIELD

[MK_QSL]

Try

MakeDate (Year, Month, 01) AS Date

If 01 dont work use '01'