Hello. I have created a slice: which I have a filter condition as such:[Timestamp]>“12/31/2021 23:59:59”
This means that every year I have to change it to show only items in the year (example: 2022). So all entries prior to 2022 are filtered out. I’ve created another datasource [DateControl] which calculates the time date of the previous year, has a Column called [DateTime].
I want the filter condition to use that datasource and column [DateTime]. I’ve made the new filter condition this: [Timestamp]>DateControl[DateTime] but it is unable to read it. Is it because the cell is a calculation?
Not sure your exact requirement but in general it sounds that you are trying to filter records with date time stamp only in the current calendar year. This can be shown by using AppSheet expression, something like
[Timestamp]> =DATETIME(TEXT(TODAY(), “YYYY/01/01”)) will achieve what you are trying to do through a separate table and data source.
Please test and let us know if you are looking for something else.
In your screenshot, the ID column is empty. Maybe that’s part of the problem?
Regardless, in case it’s helpful, you could simply define the slice’s filter to directly reference the current year rather than rely at all on setting that somewhere else.
