Elapsed days

[Alex H]

Hi is there any way to calculating the number of days elapsed between
current date and the previous 1st August?

Thanks
A

 

[JohnFol]

datediff("d","1 aug " & str(year(date) - 1 ), date())

 

[Alex H]

Thanks John

 

[Douglas J. Steele]

On the off-chance that you might have a user whose system isn't English,
it's better to use

datediff("d", DateSerial(year(date) - 1, 8, 1), date())

 

[John Spencer (MVP)]

It the date is August 2, I believe that formula will give you 366 days (367 leap
years) instead of 1 day. Is that what you want? I think the following untested
formula will give you the numbers you expect.


DateDiff("d", DateSerial(Year(Date()) + Format(Date()"MMDD") < "0801",8,1),Date())

If JohnFol is correct then ignore

 

[Douglas J. Steele]

Oops. MUCH better point than mine, John!