AnsweredAssumed Answered

Removing Repeating Month in Field if it is the same month

Question asked by jl2012 on Feb 8, 2014
Latest reply on Feb 9, 2014 by jl2012

Title

Removing Repeating Month in Field if it is the same month

Post

     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!

     J

Outcomes