Date Logic

[abhaysingh]

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

[settu_periasamy]

Hi,

Try this..

Makedate(Year,Month(Date#('Apr','MMM'))) as Date

if your Month is properly formatted, you can just use MakeDate(Year,Month)

[abhaysingh]

No settu, i am getting dates as Calendar year only

[jagan]

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.

[Anonymous]

only one date for Every month?

like 01-01-2016 for Apr, no other dates?

[PradeepReddy]

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