Formula to display the quarter (1,2,3,4) of a date

[juergenheise]

Is there a formula that displays the quarter of a date, as you can do with Month() or WeekNumber()?

[Christiaan_Huizer]

hi @juergenheise , have a look here:

How to Coda your quarters?

cheers, christiaan

[juergenheise]

Thank you, Christian.

[Troy_Larson]

Also, I have a new pack for this that has the calculation built-in.

NEW PACK: Date/Time Magic

I am constantly reusing the same date/time formulas, so I thought it would interesting to make an “uber”-datetime object. My idea was: “What information can I :tangerine:squeeze out of JUST a single date/time?” (JUST the date/time–not passing in timezone or “Week starting on Monday, etc”) This pack has a bit of overlap with the Coda date object, but my goal here is to create a mega-date object with a lot of helpful baked in formulas. For the week formulas, I created one property for each day …

[juergenheise]

Hi Troy, I added your pack. The formula works fantastic. Great job.