0

Report Weekly / Monthly

Hi,

I have a date/time field in my invoice database and need to do a report between 2 dates, is this possible?

I don't see where I could enter the 2 dates.

Thanks,

Dave

3 replies

null
    • Support
    • 6 yrs ago
    • Reported - view

    Create a new column (type formula) and give this formula:

    –––
    yearmonth('Date field')
    –––

    Now you can group and filter by this new column.

    Birger

    • Dave_Baxter
    • 6 yrs ago
    • Reported - view

    Hi,

    That works fine for monthly but how can I do weekly?

    Thanks,

    • Dave_Baxter
    • 6 yrs ago
    • Reported - view

    It's ok, worked it out. Obviously yearweek('Date field')

    Thanks

Login to reply

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 2368Views