Is there a way to get a date difference in months ...
# generale
Edgar Valdés
06/08/2021, 5:39 PMIs there a way to get a date difference in months in a Saved Search?
Edgar Valdés
06/08/2021, 5:45 PMRight now, I have this
Edgar Valdés
06/08/2021, 5:45 PM Copy code
ROUND((TO_DATE({inventorynumber.expirationdate})-TO_DATE({today}))/30)t
Tristan Day
06/08/2021, 7:09 PMuse "months_between"
e
Edgar Valdés
06/08/2021, 11:09 PM🤦♂️
Edgar Valdés
06/08/2021, 11:09 PMEs correcto
Edgar Valdés
06/08/2021, 11:10 PMThanks @Tristan Day it's so obvious in hindsight
👍 1