I tried this out and failed. (Slightly redacted) error message from F12 land:
Errors in criteria parser for expression:
Project_GoldStickerDate_c >= ‘2024-12-24T00:00:00’ AND Calculated_GoldStickerDate2 <= &Today
Errors: invalid token: &
First one is a non-dynamic date. Second one (in bold) is dynamic.
It’s trying to compare my BAQ date to a token - rather than the date represented by the token. When it fails, it ignores ALL criteria and returns the whole dataset.
So… how do I get it to compare it to an actual date (but still use the token)?
As @hmwillett pointed out, there are 3 EpBindings, but I don’t see one for “This stores the date that the token represents.”
So there’s a built-in library to decode it, but the only good way to access it is to create a Function and call it from App Studio.
[Rant ahead]
It would have been nice if they had just built the Token Date to put the resulting date into EpBinding.
Like the way that it does (or seems to) when you submit a report to the task agent.
This is a pic I took for a different reason, so ignore the orange. The point is the green circle and arrow. The ToDate AND the ToDateToken are populated on a dynamic selection. Great! So they must be secretly doing the same kind of conversion. It’d just be nice if it was done already in the Token Date widget in App Studio.
As it is, Token Date is kind of useless without your helper function.
