Custom Date Range: Fixed start date to current day

Avatar

Avatar
Level 1
bridgidp8037442
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
bridgidp8037442
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
bridgidp8037442
Level 1

14-06-2018

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

Replies

Avatar

Avatar
Validate 1
Level 4
rameshk28785
Level 4

Likes

46 likes

Total Posts

76 posts

Correct reply

22 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
rameshk28785
Level 4

Likes

46 likes

Total Posts

76 posts

Correct reply

22 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
rameshk28785
Level 4

14-06-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).

Rolling Dates.PNG

Hope It helps

Avatar

Avatar
Level 1
bridgidp8037442
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
bridgidp8037442
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
bridgidp8037442
Level 1

14-06-2018

Hi,

Thanks for your response, yes that does help!

Avatar

Avatar
Boost 1
Level 1
Trele_Morele
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Trele_Morele
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
Trele_Morele
Level 1

06-07-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?3.png

Avatar

Avatar
Boost 1
Level 1
Trele_Morele
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Trele_Morele
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
Trele_Morele
Level 1

27-07-2018

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