Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to create month start from year and Month?
Makedate( YEARFIELD, MONTHFIELD)
Already Tried not working
Use the makedate functions
makedate(year, month)
e.g. makedate(2016, 2)
without the day parameter makedate will return the first of the month.
What do you mean with 'not working'? How does your field values for YEAR and MONTH look like?
Hi Abhay,
=makedate(2016)
Output : 01-01-2016
=Makedate(2016,5)
Output 01-05-2016
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
];
Hi All,
i have year 2016, and month like jan,feb etc.
m tried before posting this monthstart(year,month)
try like this...
=makedate(2016,month(date#('Mar','MMM')))
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
];