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?

[sunny_talwar]

Maybe you need to use 1, instead of 01. Try this:

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

[Anonymous]

Hi

its working for me

dual(MakeDate(2011,01,3),'MMM/DD/YYYY')

[stephenedberkg]

no it is not work

[anbu1984]

Do you have integer values or alphabets(Jan,Feb,..) in Month field?

[stephenedberkg]

it is also not working for me

[sunny_talwar]

You need integer values for year and month. If you don't have that, then you need to transform them into integers. For months you might be able to use a mapping load and applymap.

Best,

Sunny

[stephenedberkg]

Alphabets(jan, feb )

like

[stephenedberkg]

how to change alphabets to interger

[Anonymous]

It's not going to work if you month field is string like Jan, Feb...

Try

date(date#(year & month, 'YYYYMMM'))