Expand my Community achievements bar.

SOLVED

Fusion Date functions: locate objects updated within last 2 days

Avatar

Level 6

Hi. What would be the syntax in Fusion when I want to retrieve and object only if it was last updated within the last 48 hours or 2 days: 

 

Mylah_0-1704829813018.png

 

Sorry if this is documented elsewhere, but I couldn't locate this detail in my Searches. 

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

you would want to do add days and then use a negative number to go back 2 days. 

 

addDays({now};-2)

 

There is some documentation here on functions in fusion

 

https://experienceleague.adobe.com/docs/workfront/using/adobe-workfront-fusion/functions-in-fusion/d...




View solution in original post

3 Replies

Avatar

Level 6

I think I found the solution on this thread: https://experienceleaguecommunities.adobe.com/t5/workfront-fusion-2-0-questions/wildcard-date-filter...

 

Does this look right?: 

Mylah_0-1704830030019.png

Thanks in advance for your help. 

Avatar

Correct answer by
Community Advisor

you would want to do add days and then use a negative number to go back 2 days. 

 

addDays({now};-2)

 

There is some documentation here on functions in fusion

 

https://experienceleague.adobe.com/docs/workfront/using/adobe-workfront-fusion/functions-in-fusion/d...




Avatar

Community Advisor

Instead of doing it in a filter, you could just add it as a parameter to your query, to the effect of

 

lastUpdateDate = {today -2}

lastUpdateDate_Mod = gt