0

Start & end dates in DataslayerQueries sheet get replaced on refresh


Avatar
Chris Georgakopoulos

The start and end dates could be references to other cells in the workbook. Their values shouldn't be replaced if the query is not modified from the sidebar. The same applies for other cells in the configuration sheet, all the configuration could be dynamically generated. What's the need of replacing the values on each refresh?

A

Activity Newest / Oldest

A

Antonio Barral

Status changed to: Closed

A

Antonio Barral

Hi Chris,

Both start date and end date are only modified in a refresh when the date range is a predefined interval (e.g: last month, last 1 week, last 2 years, etc...). If start date and end date are static, they will not change with the refresh.

Let is know if this was the issue you were asking about and if we can help you with something else!