Custom Date Range: Fixed start date to current day | Community
Skip to main content
B
bpurcel
June 14, 2018

Custom Date Range: Fixed start date to current day

  • June 14, 2018
  • 2 replies
  • 5475 views

Hi,

I'm working on a project in Workspace and I would like to specify a fixed start date but an end date that will always be the current day.

I'm not sure how to achieve this using the standard date options available, nor can I figure this out using a custom date range.

If anyone could help with this problem that would be appreciated!

Many thanks,

Bridgid

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

R
RameshAnalytics
Level 4
June 14, 2018

Hi,

Use Rolling Dates, rolling dates allow you to generate a dynamic report that looks forward or backward for a set period of time based on when you ran the report. You have the option to select start date and end date. In the End date option you can select as "Current Day" (see the below screenshot).

Hope It helps

Trele_Morele
Trele_Morele
July 6, 2018

How this can be done in Report Builder within Edit Group function?
I have this window, and I think I tried every date format in From: field.
What do you think?

    Trele_Morele
    Trele_Morele
    July 27, 2018

    In the end I chose the dates from cells and made an excel formula for cw-1d.

    B
    bpurcelAuthor
    June 14, 2018

    Hi,

    Thanks for your response, yes that does help!

    Terms & ConditionsAccessibility statement

    Loading footer...