Removing Repeating Month in Field if it is the same month
I created a calculation combining multiple fields in my rental database. The result I am looking for is something similar to this:
John Doe (Jan 8-14)
I am trying to figure out how to get the month to only appear once in my calculation...only if it is the same month. Here is the calculation I have so far:
Guest Name & " " & "(" & Left(MonthName ( DateStartConvert );3) & " " & Day ( DateStartConvert ) & "-" & Left(MonthName ( DateEndConvert );3) & " " & Day ( DateEndConvert ) & ")"
For stays that that extend over multiple months it would be great for the calculation to look like this:
John Doe (Jan 8-Feb 4)
Any help with this would be greatly appreciated!