Date Stamp

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Morning All,

I have a database that tracks reports. Since these are military reports,
the dates of the reports are listed like this. 250930 Jul 08 (DayTime Month
Yrs). My form is a continues form that displayed the reports that were read
and commended on. I would like to only view the last 60 days of reports
entered. Is there a way to get only the last 60 days report to be view with
this DateTime format. My other thought was to possibly have a hidden field
that date stamped as an entry was made and had the database filter to display
only the last 60 days in that manner.

Any and all recommendation would be greatly appreciated.
 
Try Using one field, not displayed, for the selection with criteria Between
Date()-60 AND Date() and another for display.
Report: Format([YourDateField], "ddhhnn mmm yy")
 
Karl,
I don't really understand where you are telling me to enter the criteria. I
only know of criteria’s in building queries. And I’m not working with on now.
With that being said, I misspoke in my original post. It’s not a report as
in a Access Report. It’s simply my form view. The current fields in the
continuous form are:
[msg number], [msg date], [msg type], [review date], [analyst], [team],
[analyst rmks]

When viewing this form, I would like it to only display the messages with a
[msg date] of today -60. The [msg date] is in the military Date Time Group
format.
250930Z Jul 08 (I forgot the Z=Zulu time; it doesn't change) This is why I
thought that having a hidden field that record the enter date to filter by.
Possible name for field is [entry date].
 
I have changed the source to a query, but one more question. How do I get an
automatic date stamp in the field.
--
Work is sometimes hard....but someone has to do it.


KARL DEWEY said:
Use a query as source for your form. Put criteria in the query.
--
KARL DEWEY
Build a little - Test a little


Pierre said:
Karl,
I don't really understand where you are telling me to enter the criteria. I
only know of criteria’s in building queries. And I’m not working with on now.
With that being said, I misspoke in my original post. It’s not a report as
in a Access Report. It’s simply my form view. The current fields in the
continuous form are:
[msg number], [msg date], [msg type], [review date], [analyst], [team],
[analyst rmks]

When viewing this form, I would like it to only display the messages with a
[msg date] of today -60. The [msg date] is in the military Date Time Group
format.
250930Z Jul 08 (I forgot the Z=Zulu time; it doesn't change) This is why I
thought that having a hidden field that record the enter date to filter by.
Possible name for field is [entry date].
Click to expand...
Click to expand...
 
Either in the table or form in design view set the default property to
=Now() to have date and time or =Date() for just date.
--
KARL DEWEY
Build a little - Test a little


Pierre said:
I have changed the source to a query, but one more question. How do I get an
automatic date stamp in the field.
--
Work is sometimes hard....but someone has to do it.


KARL DEWEY said:
Use a query as source for your form. Put criteria in the query.
--
KARL DEWEY
Build a little - Test a little


Pierre said:
Karl,
I don't really understand where you are telling me to enter the criteria. I
only know of criteria’s in building queries. And I’m not working with on now.
With that being said, I misspoke in my original post. It’s not a report as
in a Access Report. It’s simply my form view. The current fields in the
continuous form are:
[msg number], [msg date], [msg type], [review date], [analyst], [team],
[analyst rmks]

When viewing this form, I would like it to only display the messages with a
[msg date] of today -60. The [msg date] is in the military Date Time Group
format.
250930Z Jul 08 (I forgot the Z=Zulu time; it doesn't change) This is why I
thought that having a hidden field that record the enter date to filter by.
Possible name for field is [entry date].
Click to expand...
Click to expand...
Click to expand...
 
Back
Top