Discussions

Expand all | Collapse all

How to calculate the date of the first day of the week of a date

  • 1.  How to calculate the date of the first day of the week of a date

    Posted 22 days ago
    I am trying to create a line chart report that charts weekly sales progress in a chart in a table that records the sales numbers daily. How would I plot "Week of mm/dd/yyyy" on the X axis of the line chart? Thanks!

    Here is what the chart presently looks like with each day in the X axis:


    ------------------------------
    Matt Makris
    ------------------------------


  • 2.  RE: How to calculate the date of the first day of the week of a date

    Posted 22 days ago
    np,
    Set he report to group the date "by week" instead of "by day".

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: How to calculate the date of the first day of the week of a date

    Posted 22 days ago
    Thank you. It was right in front of me 🤦‍♂️ lol

    ------------------------------
    Matt Makris
    ------------------------------