Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have year colum separately and month date colum as "mm, dd" .
I want to combine this and make date when loading.
Thanks
try this
makedate('2017',mm,dd)
i have several year so it doesnot work,
Date(Date#((tempYear & ',' & Date),'YYYY,MMM, DD'), 'YYYY-MMM-DD') as mydate, solve the issue
Thanks
Hi please try per the attached QVW, this might help
It should be
Date (MakeDate(tempYear,monthfield),'YYYY-MMM-DD') as datefield
you can create like below also
Year&'-'&Month&'-'&Date as salesYearMD