I have a few sheets under a app called Laboratory Operations and within these sheets. I have a datepicker. I set two variables in my data load editor:
let vDefToday = date(Today(),'MM/DD/YYYY');
let vDefLastWeek = date(Today(-7), 'MM/DD/YYYY');
within the datepicker I set the start and end date to these variables but i still dont see it replicated in the graphs kpis and other tools that are within the sheet.
the date picker is using this field:
DATE(Floor([RECEIVED_DATE]),'MM/DD/YYYY') as [RECEIVED_DATE],
any tips?