Does anyone know a workaround to populate the current or last WeekID (EPTimeCard.WeekID) in a parameter on a GI. I have a few use cases for this and in order to use the GI’s for Dashboards I need this filter to be applied. As a workaround I know I can use weekstart as its a field on EPTimeCard but this is less user friendly as users would be able to pick dates other than week start dates from the dropdown.
For example you can use @today or @weekstart-1 for a specific date field but I have been unable to figure out the logic to do this for a WeekID if its even posable.
Thanks in advance for any suggestions. Attached is a GI I’m using to show missing timecards.