Month Creation Using Two Fields

[Anonymous]

Hi ,

I have two fields FROM DATE & TO DATE. It is monthly data. I need to create month name field using these two dates

FROM DATE	TO DATE
2018-01-01	2018-01-01
2018-01-01	2018-03-01
2018-02-01	2018-02-28
2018-03-01	2018-03-31

I need month name

[dapostolopoylos]

Use Month(FROM DATE) and Month(TO DATE)

[wilsonwebb]

HI Apoorva,

Use:

'TableName':

Load

Date(Month([FROM DATE]),'MMMM') as MonthFromName,

Date(Month([TO DATE]),'MMMM') as MonthToName

[MarcoWedel]

Can you post your expected result as well based on your sample data?

[Anil_Babu_Samineni]

I can think like this?

Table_Load:

Load [FROM DATE] as DateField From Table;

Join

Load [TO DATE] as DateField From Table;

Final:

NoConcatenate

Load DateField, Month(DateField) as Month Resident Table_Load:

Drop Table Table_Load;

[Anonymous]

give example using interval match

[avinashelite]

could you give the same output required ?

[jyothish8807 · Accepted solution]

Hi Apoorva,

Try like this:

First create a master calendar using  min(From Date) and Max(To Date) and Name it "Date" field.

Then:

A:

Intervalmatch(Date)

Load distinct

[To Date],[From Date] resident <Yourtable>;

Br,

KC