Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please see my example below. How do I combine yearmonth and yearmonth2?
Do you just want them concatenated together?
year([Intake Date]) & '/' & month([Intake Date]) & ' - ' & year([Close Date]) & '/' & month([Close Date]) as CombinedDate
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;
Thanks