Combine Year with month/day

[anuradhaa]

Hi,

I have year colum separately and month date colum as "mm, dd" .

I want to combine this and make date when loading.

Thanks

[arulsettu]

try this

makedate('2017',mm,dd)

[anuradhaa]

i have several year so it doesnot work,

Date(Date#((tempYear & ',' & Date),'YYYY,MMM, DD'), 'YYYY-MMM-DD') as mydate, solve the issue

Thanks

[punitpopli]

Hi please try per the attached QVW, this might help

[vinieme12]

It should be

Date (MakeDate(tempYear,monthfield),'YYYY-MMM-DD') as datefield

[ramasaisaksoft]

you can create like below also

Year&'-'&Month&'-'&Date as  salesYearMD