This week last year to this date range showing incorrect date comparison | Community
Skip to main content
juliusonyancha
juliusonyancha
Level 4
August 5, 2024
Solved

This week last year to this date range showing incorrect date comparison

  • August 5, 2024
  • 1 reply
  • 1022 views

Hi all,

 

I'm trying to compare last week (29th July 2024 to 4th Aug 2024) to the same period last year using (This week last year to this date range). However, I get below which is incorrect, ideally, it should be 31st - 6th July 2023.

 

 

Has anyone experienced this before?

 

Thanks.

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

You can edit the date range if its not what you need.

 

Can you show us what the rules being used are?

 

 

For example, when I set my panel to "Last Week" and use the "This week last year to this date range", I get "July 28, 2023-Aug 3rd, 2023", and yeah, I am not liking that (since it's not running with my "Sunday to Saturday" week....

 

So if I edit it, I get this definition (which looks completely wrong.. something might be up with the auto-calculated dates again... not the first time):

 

 

So I would ideally like to get a Sun-Sat, so I will change the definition to:

 

 

This looks a lot better.... now, if your weeks are Mon-Sun, this should probably work for you... If not, play with the definition until you are happy..  

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
August 5, 2024

You can edit the date range if its not what you need.

 

Can you show us what the rules being used are?

 

 

For example, when I set my panel to "Last Week" and use the "This week last year to this date range", I get "July 28, 2023-Aug 3rd, 2023", and yeah, I am not liking that (since it's not running with my "Sunday to Saturday" week....

 

So if I edit it, I get this definition (which looks completely wrong.. something might be up with the auto-calculated dates again... not the first time):

 

 

So I would ideally like to get a Sun-Sat, so I will change the definition to:

 

 

This looks a lot better.... now, if your weeks are Mon-Sun, this should probably work for you... If not, play with the definition until you are happy..  

    juliusonyancha
    juliusonyanchaAuthor
    Level 4
    August 7, 2024

    Thanks @jennifer_dungan my week runs from Mon-Sun, it works when manually editing it but thought it can work with auto dates.

      Jennifer_Dungan
      Community Advisor and Adobe Champion
      Jennifer_DunganCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      August 7, 2024

      The auto dates should work, you're right.. but based on what I am seeing, it looks like they are having issues again...

       

      If you see my screenshot, "start of current week minus 1 week" is definitely not correct to get last year.... lol. I've seen that before and they fixed it... I think it's time for a ticket.

       

      But, luckily you can create manual fixes when required... it's an extra step, but it means you aren't stuck.

        Terms & ConditionsAccessibility statement

        Loading footer...