Post

1 follower Follow
0
Avatar

Substract dates in PODIO IF

I want to know how many days took an invoice to be paid. (this is easy and i can do it)

But, if the invoice hasnt been paid i want to know how many days have passed since it was issued.

Example:

Issue date: February 10th
Payment Date: February 15th
Payment days: 5

 

But if it hasnt been payed yet, it should be:

Issue date: February 10th
Today: February 28th
18 Days.

 

For some reason, when i try to "call" the date fields...it doesnt recognize them as dates....so it doesnt calculate.

Byron Chavarria

Please sign in to leave a comment.