Monthstart from year and month

[abhaysingh]

Hi,

How to create month start from year and Month?

[swuehl]

Makedate( YEARFIELD, MONTHFIELD)

[abhaysingh]

Already Tried not working

[Colin-Albert]

Use the makedate functions

    makedate(year, month)

e.g.   makedate(2016, 2)

without the day parameter makedate will return the first of the month.

[swuehl]

What do you mean with 'not working'? How does your field values for YEAR and MONTH look like?

[#6]

Hi Abhay,

=makedate(2016)

          Output :   01-01-2016

=Makedate(2016,5)

          Output  01-05-2016

[MayilVahanan]

HI

May be try like this, if your month is in text

LOAD *, MakeDate(Year, MonthNum) as Date;

Load *,  Month(Date(Date#(Month,'MMM'),'MMM')) as MonthNum Inline

[

Year, Month

2015, Apr

2015, Jan

2015, Mar

];

[abhaysingh]

Hi All,

i have year 2016, and month like jan,feb etc.

m tried before posting this monthstart(year,month)

[PradeepReddy]

try like this...

=makedate(2016,month(date#('Mar','MMM')))

[sunny_talwar]

What if we do it all in one step Mayil?

May be something like this:

Load *,

        MakeDate(Year, Month(Date#(Capitalize(Month), 'MMM'))) as Date 

Inline

[

Year, Month

2015, Apr

2015, Jan

2015, Mar

];