Skip to main content
Solved

Count since the 1st of the month

D

Hello the Community,

I’m sorry for this stupid question, or, at least, a question coming from a beginner… but didn’t find my answer since days!
I have to manage a coaching data base, where I follow each appointment with the Coachee’s Name, the Coach’s Name, the date of the appointment, the debriefing etc…
And I would like to create an indicator showing the number of coachings done by a coach since the 1st of the current month. I don’t want a count since the past 30 days, but since the 1st day of the month.
For example: we are the 22nd of Jan and I would like to count the number of coachings done since the 1st of jan… not since the 22nd of december.
And of course, I would like to have it in an automatic way to follow it each month.

Thanks a lot for your help!

Best answer by Kamille_Parks11

For the appointments table, make a new formula field that looks something like this

IF(DATETIME_FORMAT({Date field}, 'YYYYMM') = DATETIME_FORMAT(TODAY(), 'YYYYMM'), "count", BLANK()

^ That will show the word “count” on every appointment record which happened this month. Then you use conditional a Count field in the Coach table to count each coach’s appointments for the current month.

View original
    Did this topic help you find an answer to your question?

    2 replies

    Kamille_Parks11
    Forum|alt.badge.img+25

    For the appointments table, make a new formula field that looks something like this

    IF(DATETIME_FORMAT({Date field}, 'YYYYMM') = DATETIME_FORMAT(TODAY(), 'YYYYMM'), "count", BLANK()

    ^ That will show the word “count” on every appointment record which happened this month. Then you use conditional a Count field in the Coach table to count each coach’s appointments for the current month.

    D
    1 person likes this
    • D
      Damien_Fancelli
    D
    Kamille_Parks11 wrote:

    For the appointments table, make a new formula field that looks something like this

    IF(DATETIME_FORMAT({Date field}, 'YYYYMM') = DATETIME_FORMAT(TODAY(), 'YYYYMM'), "count", BLANK()

    ^ That will show the word “count” on every appointment record which happened this month. Then you use conditional a Count field in the Coach table to count each coach’s appointments for the current month.


    Wonderful! Thank you so much!! :pray: :pray:

    Reply


    Most helpful members this week

    Terms & Conditions