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    
post Jun 2 2020, 11:55 AM

Posts: 781
Joined: 7-May 11

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

Go to the top of the page
post Jun 2 2020, 12:18 PM

UA Admin
Posts: 37,521
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
post Jun 2 2020, 03:34 PM

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    16th July 2020 - 10:06 AM