AnsweredAssumed Answered

Format dates for multi day events

Question asked by jlisburn on Jun 13, 2014
Latest reply on Jun 17, 2014 by jlisburn

Situation:

 

  • Quoting a client, giving possible dates to provide service.

 

  • Using a Repeating Date field for this as we may want 1-5 dates on each quote

 

  • Some of our Products are multi-day events, they have a stated DurationDays

 

  • Need to re-display these multi-day events later in the busines process: EG Jun 6-8, Aug 15-17 etc outside of FileMaker, so layout formatting cannot be used. I need to maipulate the data (idealy by calc and not script)


Problem lies in showing events that span months - Jun30-Jul 1, get sdisplay as June 30-31

 

Seems I'm going to need a very complex calc, or custom function but I can't determine which/how to go about it.

Outcomes