A
Alex H
Hi is there any way to calculating the number of days elapsed between
current date and the previous 1st August?
Thanks
A
current date and the previous 1st August?
Thanks
A
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JohnFol
datediff("d","1 aug " & str(year(date) - 1 ), date())
A
Alex H
Thanks John
D
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())
it's better to use
datediff("d", DateSerial(year(date) - 1, 8, 1), date())
J
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
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
D
Douglas J. Steele
Oops. MUCH better point than mine, John!