Count Number of days between 2 dates

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Count Number of days between 2 dates

Post by burrina »

Not sure in a query which is correct or none!

Code: Select all

DateDiff("d",[#2/17/2021],[#02/22/2021])
DD:DateDiff("d",[SomeDateField],Date())

Diff1:([SomeDateField]=#2/17/2021)
Diff2: ([SomeDateField]=#02/22/2021)
NumOfDays: ("d",[Diff1],[Diff2])

CountOfDays:[#2/17/2021]-[02/22/2021]

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Count Number of days between 2 dates

Post by HansV »

The ony correct one is

Code: Select all

DD: DateDiff("d",[SomeDateField],Date())
You could also use

Code: Select all

DD: Date()-[SomeDateField]
If you want to use a fixed, literal date, enclose it in # on both sides, and don't use [ ].
For example today (the 26th of February) is #2/26/2021#
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Count Number of days between 2 dates

Post by burrina »

Many Thanks, I appreciate it.