When trying to set advanced date range with a fixed date (July 1st, 2024) and a dynamic end date (Today minus 1 month, or today minus 1 day), which clearly translates to a date after July 1st, 2024, the date range selector doesn't allow setting the date, giving this error: End date is earlier than start date despite showing the end date (in case of screenshot Mar 31, 2025) which is in fact later than the start date.
still a bug on both regular & auto date range selectors
This bug has been reported to the Google Looker team previously. Please wait for their response!
You need to try adjusting the end date settings back and forth to get around the bug, e.g. by first setting the number (days, weeks, etc.) to 0 and then changing it to the value you want. Usually works - worth trying!
Just added the below to my dashboard, where I want to show YTD (ISO week) compared to the previous year in a score card.
That sometimes works for me, however try explaining that to 300+ consultants trying to use your boards!! 😞