Announcement

Collapse
No announcement yet.

Formula to show quarters in a field

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

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

    Leave a comment:


  • Nishan Perera
    commented on 's reply
    Thanks. Appreciate it if you could give me an actual example of this.

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

    Leave a comment:


  • Nishan Perera
    started a topic Formula to show quarters in a field

    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
Working...
X