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]
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]
Code: Select all
DD: DateDiff("d",[SomeDateField],Date())
Code: Select all
DD: Date()-[SomeDateField]