Wildcard date filters in Fusion? | Community
Skip to main content
BrandonNW
BrandonNW
Level 6
October 15, 2021
Solved

Wildcard date filters in Fusion?

  • October 15, 2021
  • 1 reply
  • 785 views

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.
Best answer by Richard_Le_

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.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
October 15, 2021

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.

    BrandonNW
    BrandonNWAuthor
    Level 6
    October 18, 2021

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

    Terms & ConditionsAccessibility statement

    Loading footer...