Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Location
    Florida
    Posts
    3

    Access Date/Time....I need a "generic" date.


    I, by no means, am proficient in Access. However, my probem is that in an event tracking spreadsheet, I have a field designated as "End Date". The data type is set at Date/Time. Usually, I have valid dates to populate the data, however; there are certain dates that need more generic dates. What I mean is, cells where a date or value is needed to be entered, but the date is currently unknown (right now I have entered "1/1/1900", but that does not stand out enough)....this is where I would like to enter in either text or, preferrably "0/00/0000". Ideally, I would like to enter in the date "0/00/0000". Is there any way to do that?

  2. #2
    wazz is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2005
    Location
    Vancouver
    Posts
    2
    using dummy values is usually not a good idea. can you use the same approach but with a null value? i.e., instead of putting in a "meaningless value" leave it null and make NULL your "meaningless value"; instead of checking to see if the value is 00/00/0000, check to see if it is null. hth.

  3. #3
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    I agree with wazz--IMHO, you are better off with a null.

    If your concern is making it stand out, and if you are in Excel, I would recommend that you use Conditional Formatting to do something like make the whole row red if the date field is null (or just that cell, if you prefer).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2003 Date() Function returns "#Name?"
    By smartel@soprema.ca in forum Programming
    Replies: 5
    Last Post: 01-18-2012, 05:52 AM
  2. Replies: 0
    Last Post: 09-25-2008, 12:19 PM
  3. Export to .rtf of "104-" converts to "-655&qu
    By Sherri726 in forum Import/Export Data
    Replies: 0
    Last Post: 12-19-2006, 03:16 PM
  4. Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums