Question on Date in a tble (1 Viewer)

Lensmeister1968

New member
Local time
Today, 14:28
Joined
Feb 12, 2024
Messages
2
Good evening all,

I have started building some table in a DB I'm hoping to create.

In the Table TOC
I have a field for a date.
Many of the dates are older ones.
BUT
There are a number of then that are on going so I need only those ones to be the current date when the DB is opened.
Is this possiblt if so how ?

Thanks in advance.
 

XPS35

Active member
Local time
Today, 15:28
Joined
Jul 19, 2022
Messages
160
Use a query to select the records with the current date. Something like
Code:
SELECT * FROM TOC WHERE TocDate = Date()
 

Gasman

Enthusiastic Amateur
Local time
Today, 14:28
Joined
Sep 21, 2011
Messages
13,881
You need some sort of rule.
If you cannot do it on paper, you cannot do it in Access.
 

oleronesoftwares

Passionate Learner
Local time
Today, 06:28
Joined
Sep 22, 2014
Messages
1,159
hi,
i don't seem to understand what you are trying to achieve, snapshots of your table will help me understand better. Though a select query as record source should help you achieve what you want.
 

mike60smart

Registered User.
Local time
Today, 14:28
Joined
Aug 6, 2017
Messages
1,889
Good evening all,

I have started building some table in a DB I'm hoping to create.

In the Table TOC
I have a field for a date.
Many of the dates are older ones.
BUT
There are a number of then that are on going so I need only those ones to be the current date when the DB is opened.
Is this possiblt if so how ?

Thanks in advance.
Can you upload the database?
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 08:28
Joined
Feb 28, 2001
Messages
26,838
What I did for "future dates" was that ALL dates that didn't default to Now() or Date() (today's date with or without seconds) would default to 31-Dec-9999, which is the largest - and most distant - future date you can have. Easy to trap, too, because the day number is absurdly large. Doing that, I was easily able to exclude dates with something like "WHERE .... AND ( EventDate <> #31-Dec-9999# ) AND ...."
 

Users who are viewing this thread

Top Bottom