RE: 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

Add Comment
1 Answers

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 5 days ago.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.