combine date field

[#1]

Please see my example below.  How do I combine yearmonth and yearmonth2?

[joshabbott]

Do you just want them concatenated together?

year([Intake Date]) & '/' & month([Intake Date]) & ' - ' & year([Close Date]) & '/' & month([Close Date]) as CombinedDate

[its_anandrjs]

As i understand you have to create single field as yearmonth if so then again load the table and concatenate this tables

Ex:-

Load

year([Intake Date]) & '/' & month([Intake Date]) as yearmonth

and other fields

From Location;

Concatenate

Load

year([Close Date]) & '/' & month([Close Date]) as yearmonth

and other fields

From Location;

[#4]

Thanks