Incomplete Dates on Report

[Dave Titan]

Small prob giving me a headache here

I have a list of dates in order. However the boss came up with some new dates a while ago, unfortunately they are incomplete dates. ie April, or TBD. My date format is 02/4/2003 or 2nd April 2003.

I've tried changing the format on the time date field, but cannot get just april or the 4th to appear as it's an invalid or incomplete entry

Example


2/3/2003 Bowling
16/4/2003 Hockey
4/2003 Bowling ---- This is what I need
19/4/2003 Bowling

 

[DJN]

Hi Dave. In the format field of the date/time field add m/yyyy That should format the field as you want it. This will however, change ALL records in the table the next time you open it.


David

 

[vandewi]

You could use a particular, and impossible date to flag the TBD (example #12/31/9999#).

Your record source would then be:
=iif([YourDateField]=#12/31/9999#,"TBD",[YourDateField])

As for the partial date that you are being supplied, you could just use the 1st of the month, and maybe and a yes/no field to your table to flag the date as "Not confirmed".

 

[3699wat]

Open properties of the fields in the table. Click on the data type tab. Enter mm/yyyy in the format box.

 

[vandewi]

The suggestion from 3699wat will change your date format across the board. Since many of the dates that you have entered do require the full date format, this will not work for you.

 

[Dave Titan]

Thanks for the help.

I'll say I'll go for the extra column to say whether it's been confirmed or not.

As just having the month in there provides in acurate info as the majority of dates have days months and years.

It's strange that Access doesn't offer something more reasonible for this as I'm sure not everyone has a confirmed date!!