How to Calculate from Current Time and Date

Beto
Mega Guru

How do I calculate from current time/date to Go-Live date and output to Days Remaining?

Go-Live Date: u_go_live_date

Days Remaining: u_days_remaining

 

find_real_file.png

5 REPLIES 5

It's because you're subtracting it in reverse then...the formula is suppose to be calculated using (oldest date, newest date)...

but if your start date is today...and the other date was 10 days ago...then when you're subtracting the other way around, that may be causing it to be all wonky.

If today's date is always going to be after the go live...which shouldn't be...then you'd need to swap your formula around.

Try looking at it with a go-live that is a few days ahead..like 4-5 days or something...then what does it say?


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!