Current date

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

Is there a way to create a calculated field in a query
that tells the current date in terms of the count of days
since January 1? Any help would be great! thanks, matt
 
matt said:
Is there a way to create a calculated field in a query
that tells the current date in terms of the count of days
since January 1? Any help would be great! thanks, matt
Click to expand...

DateDiff("d", DateSerial(Year(Date()), 1, 1), Date())
 
Is there a way to create a calculated field in a query
that tells the current date in terms of the count of days
since January 1? Any help would be great! thanks, matt
Click to expand...

DatePart("y", Date())
 
Is there a way to create a calculated field in a query
that tells the current date in terms of the count of days
since January 1? Any help would be great! thanks, matt
Click to expand...

NumOfDays:Datepart("y",Date())
 
Back
Top