Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have Year and Month as per Fiscal Year in a table, like year 2015 and their Month
Apr,May,Jun, Jul ,Aug, Sep,Oct,Nov,Dec,Jan,Feb,Mar
So i want to create the date like below
01-01-2015,
01-02-2015,
01-03-2015
01-04-2015
01-05-2015
01-06-2015
01-07-2015
01-08-2015
01-09-2015
01-10-2016
01-11-2016
01-12-2016
kindly suggest
Hi,
Try this..
Makedate(Year,Month(Date#('Apr','MMM'))) as Date
if your Month is properly formatted, you can just use MakeDate(Year,Month)
No settu, i am getting dates as Calendar year only
Hi,
Attach sample data and let us know your expected output. This way it is easier to provide solution. What is Fiscal Year start date?
Regard,
Jagan.
only one date for Every month?
like 01-01-2016 for Apr, no other dates?
see the attachment, you are looking some thing like this..
Edit:
Change the date format as per your requirement..
Date(MakeDate(Year,ApplyMap('Month_Number_MAP',Month,'N/A')),'DD-MM-YYYY') as Date1