is there any way to make additions with current date? for example if I want to know if an order is due in the next 2 days, when I compare today’s date against the due date of that order it should be today’s date + 2, but I don’t know how to achieve that in samba, or if there’s a way to run SQL functions in a rule that would be helpful too.
I’m basic terms that expression takes ticket date formats it as hh:mm then it takes the value in the ticket tag multiplies it by 60 to convert it to seconds and that is added to ticket date. Then I formatted it to show as hh:mm tt
I was playing around with it, and I was able to make the addition with ticket tag, but is there any way to add days to the current date? for instance using {DATE} and add 2 days?
Using Jesse’s formula, you would want to use something like this: [=FD(ADD('{DATE}',+2),'MM/dd/yyyy')]
or this [=FD(ADD('{DATE}',+2),'ddd MM/dd/yyyy')]
Yes my example combined a couple things before it added. It may have confused you as you really needed something a little simpler like what he just demonstrated.