UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Date Function Based On Max Date, Access 2016    
 
   
ordnance1
post Jun 2 2020, 11:55 AM
Post#1



Posts: 781
Joined: 7-May 11



How can I get Date() to return the Max Date?

CODE
>=DateAdd("ww",-3,Date())
Go to the top of the page
 
GroverParkGeorge
post Jun 2 2020, 12:18 PM
Post#2


UA Admin
Posts: 37,513
Joined: 20-June 02
From: Newcastle, WA


From where would this Max date come?

Date() is a standard function that returns the current date, always.

If you want a different date from today, you would have to specify that by identifying the table and field where it will be found.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
kfield7
post Jun 2 2020, 03:34 PM
Post#3



Posts: 1,078
Joined: 12-November 03
From: Iowa Lot


see DMax() function.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th July 2020 - 05:11 AM