2 Replies Latest reply on Feb 9, 2014 4:43 PM by jl2012

    Removing Repeating Month in Field if it is the same month

    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