How to query for $$TODAY's date using Fusion

[Rafal_Bainie]

Dear WF community,
does anyone what would be equivalent of a wildcard filter plannedStartDate==$$TODAY in Fusion?

suggestions will be greatly appreciated.

And secondly, maybe even more importantly, how to offset this by user's timezone?

what is today for Someone in Tokyo is not necessarily the same for someone in San Francisco

My guess is it will have to be double condition with gt and lt conditions around exact start and end time.

let me know what you think

[KatherineLa]

In Fusion, you would want to look in the 'Date and time' config menu for those options. The option 'now' will get you the exact date/time stamp, and then I'd wrap it in a formatDate to format it to match whatever date you're comparing against. Remember to format both dates you're working with to be in a comparable format/timezone.

If you're working with fields that are already typed as date, that should work. If you're working with other fields/strings that happen to contain date information them, you may need to also use parseDate first so that Fusion understands the information is a date value. 

[lgaertner]

Hello Rafal,

in Fusion you can use 

{{formatDate(now; "YYYY-MM-DD")}}

to achieve a search query similar to 

plannedStartDate==$$TODAY

Regards

Lars