Skip to main content
BrandonNW
Level 6
Oct 15, 2021 1:26 PM UTC
Solved

Wildcard date filters in Fusion?

Is it possible to use a date wildcard in Fusion. For instance, if I wanted change the planned start date of a task to 3 days from today, or maybe backdate a project start date to last week? Can we use the date/time functions to do this?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Richard_Le_
Richard_Le_Accepted solution
Community Advisor
Oct 15, 2021 10:51 PM UTC

Hi Brandon,

Yes, you can use the date/time functions in Fusion to do this. The 'Now' variable (available in date/time functions) behaves the same as the $$NOW wildcard in Workfront. Using this in combination with the 'add days' function should render the same results as a $$TODAY+3d Wildcard in Workfront. See screenshots below:

Variable configured with adddays function

Output produced

Best Regards,

Rich.

2 replies

Richard_Le_
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
Oct 15, 2021 10:51 PM UTC

Hi Brandon,

Yes, you can use the date/time functions in Fusion to do this. The 'Now' variable (available in date/time functions) behaves the same as the $$NOW wildcard in Workfront. Using this in combination with the 'add days' function should render the same results as a $$TODAY+3d Wildcard in Workfront. See screenshots below:

Variable configured with adddays function

Output produced

Best Regards,

Rich.

Translate
BrandonNW
BrandonNWAuthor
Level 6
Oct 18, 2021 2:41 PM UTC

Boom ! Exactly what I was looking for. Worked like a charm. Thanks Rich!!

Translate