Jguido
1
I need a formula that works with General Caster that will allow me calculate the number of days between 2 given dates. Can anyone help me with this?

Example-

1/3/2023 and 1/4/2023 would = 1

1/3/2023 and 1/5/2023 would = 2

1/3/2023 and 1/2/2023 would = -1

Hello there @Jguido,

I think @rob might be able to help here

2 Likes

Jguido
3
@rob Can you help with this?

rob
5
Hey @Jguido

You can calculate the difference in days between two dates using the following GC formula.

`DATEVALUE({item's First Date}) - DATEVALUE({item's Second Date})`

1 Like

Jguido
7
@rob It keeps saying unexpected error and doesnâ€™t load the number

Jguido
9
I Solved it.

The correct formula is:

DAYS({itemâ€™s First Date},{itemâ€™s Second Date})