Announcement

Collapse
No announcement yet.

Formula to show quarters in a field

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #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.

  • #3
    Code:
    $quarter = number\floor((datetime\month($dateValue) - 1) / 3) + 1;

    Comment

    Working...
    X