Date={"<=$(=today()-1)" fails, Date={"<=$(=today())" works

[JustinDallas]

Hello Everyone,

So I've got a Set Analysis that seems to have randomly broken yesterday.  I am trying to say "any date in the past, not including today".  For that, I have

Date={"<=$(=today()-1)"

The SetAnalysis containing this gives me the infamous Dash of Doom "-" when put into a Text Object.  However, if I remove the "-1" and just have ,Date={"<=$(=today())", it works like a charm.  What is going on here?   I got my how to manipulate a date information from this response in this post by Arya v

subtract 120 days from date

Any help is greatly appreciated.

[Miguel_Angel_Baeyens]

Justin,

Try

Date = {'$(=Date(Today()-1))'}

Miguel

[marcus_sommer · Accepted solution]

Try it with: Date={"<=$(=date(today()-1, 'YourFormat'))"}

- Marcus
 

[patroser]

Hi,

you could also try this one, built with set analysis wizard

=Sum( {$<Date={"<$(=Today())"}>} Value)

Best regards,

Patrick

Edited: had an error in it, corrected it

[JustinDallas]

Thanks.  I'm still upset that it worked up till recently, and then it decided to kick the bucket.