Convert Date Difference to Number

I subtracted two dates ang got the difference between the two. The format of the result is like below:

274 days

How will I convert 274 days to just a number 274?

hi @Alyssa_Gono
good to see you asking questions, that will speed up your learning process. Below two options

the sequence() counts from date 1 until date 2 included, therefor I added minus 1


hope it helps, cheers, Christiaan

1 Like

Thank you so much. Such a great help.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.