Create date from year

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have year field contains 2014,2015,2016,2017 from which i want to create date,month and monthname. how can I do it.

give any suggestion.

Re: Create date from year

its_anandrjs — Mon, 09 Oct 2017 17:10:47 GMT

Try this from any year field create first date and then yearstart dates and year ends based on the dates then create year,month,monthname etc fields.

TempTab:

LOAD *,MakeDate(Year) as TempDate;

LOAD * Inline

[

Year

2014

2015

2016

2017

];

Dates:

LOAD YearStart(TempDate) as MinDate,YearEnd(TempDate) as MaxDate Resident

TempTab;

LET vMinDate =Floor(Peek('MinDate',0,'Dates'));

LET vMaxDate =Floor(Peek('MaxDate',-1,'Dates'));

LOAD

Date($(vMinDate) + IterNo() -1) as DateField,

Year($(vMinDate) + IterNo() -1) as Year,

Month($(vMinDate) + IterNo() -1) as Month,

MonthName($(vMinDate) + IterNo() -1) as MonthName

AutoGenerate 1

While ($(vMinDate) + IterNo() -1) <= NUM($(vMaxDate));

MarcoWedel — Mon, 09 Oct 2017 21:02:19 GMT

can you describe your expected result?