MakeDate

[stephenedberkg]

i have have the year and month filed i want to combine this year and month .

I am using

makedate(year,month,01) as date,

but this is not working can anyone help me?

[Anonymous]

Hi try this  as sunindia suggested

Date(MakeDate(year, month, 1), 'MMM/DD/YYYY') as date,

[sunny_talwar · Accepted solution]

Months:

Mapping LOAD * Inline

[months, monthNo.

jan, 1

feb, 2

mar, 3

apr, 4

may, 5

jun, 6

jul, 7

aug, 8

sep, 9

oct, 10

nov, 11

dec, 12
];

MakeDate(year, ApplyMap('Months', month), 1) as date

[stephenedberkg]

Already i tried but its not working

[anbu1984]

Makedate() need integer arguments and not alphabets. Try like this

Makedate(Year,Wildmatch(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),1) As Date

[stephenedberkg]

yeah i got it

[stephenedberkg]

yeah i got it. this is also correct.

thank you for your response

[stephenedberkg]

thank a lot sunindia

[ankitaag]

Hi Stehen,

Please convert your months to numbers.

Then use MakeDate(Year,Month,01)

[anbu1984]

If month field case doesn't match with mapping key, then you won't get result. Try Lower like this

MakeDate(year, ApplyMap('Months', Lower(month)), 1) as date

[#11]

no it should be like:

MakeDate(year, ApplyMap('Months', months), 1) as date