To fetch the date from available filter option

I need to compare the invoice due date with the date which is given by the user in the saved search. can anyone please guide? thanks in advance

Rookie Asked on January 12, 2022 in Saved Searches.
Add Comment
1 Answer(s)

Due Date is a native field – {duedate}

For the user provided date, I assume that is a custom field.

In your saved search you can show both of these fields. With a third field you could do a formula numeric field and some sort of CASE WHEN statement to do your comparison, or even a simple calculation on the dates. (Not sure specifically how you want to compare the two fields.)

Hope that helps!

Rookie Answered on January 13, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor