Formula to show quarters in a field

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Nishan Perera
    Active Community Member
    • Jan 2019
    • 348

    Formula to show quarters in a field

    Hi, I want a support to write a Formula to show quarters in a field according to a date start and date end in call
    Cheers!
    Nishan.
  • shalmaxb
    Senior Member
    • Mar 2015
    • 1602

    #2
    Your formula should calculate the days from start to end and then show an output in another field, if the amount of days fits a quarter year. Some ifThen calculations should do the job.

    Comment


    • Nishan Perera
      Nishan Perera commented
      Editing a comment
      Thanks. Appreciate it if you could give me an actual example of this.
  • yuri
    Member
    • Mar 2014
    • 8440

    #3
    Code:
    $quarter = number\floor((datetime\month($dateValue) - 1) / 3) + 1;
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    Working...