Skip to main content
Best answer

I need help getting the number of days between 2 dates

  • July 7, 2020
  • 1 reply
  • 68 views

Forum|alt.badge.img

I'm trying the accepted answer for this topic (https://community.zapier.com/ask-the-community-3/what-s-the-best-way-to-find-the-number-of-days-between-2-dates-36) but I don't get a valid result with the round formula․․․

does anyone succeeded in subtracting 2 Unix formated date and get a value different from 0 with the last formula?

the 2 formulas I’m testing return 0….

 

 

thanks for your help

Best answer by mzerbibBest answer by mzerbib

I solved my issue thanks to Zapier Support Team.

I was using using a wrong option in the number customization. switching to Spreadsheet-Style Formula solved my problem.

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Forum|alt.badge.img
  • Author
  • Beginner
  • 3 replies
  • Answer
  • July 8, 2020

I solved my issue thanks to Zapier Support Team.

I was using using a wrong option in the number customization. switching to Spreadsheet-Style Formula solved my problem.