Proper Date Format

[geraldcor]

Hello all,
On our main results form the boss wants the date to show dd First three letters of the month 2005, so dd "Mon" yyyy. Medium date does dd "Mon" yy. I need the 20 for all of the years, (or 19 for past samples). When we set up this database a long time ago we just did date arrived as a date field and formatted it to how we want. now the boss wants something that access can't do with just formatting. Is there a way that I can change this small annoyance (to him it is big). Thank you for your continued help.

Greg

 

[jon98548]

All you need to do is format the date you have. Do a simple query on that data. Make a new field called:

NewDate: Format([OldDate],"ddmmmyyyy")

That should do it.

 

[geraldcor]

Thanks for the reply. It looks good but I don't quite now what you are saying. Are you saying add ([OldDate],"ddmmmyyyy") to the Format property of the new text box? When you say run a simple query do you mean a query query or just reference the other textbox? I tried just putting the above formatting in the Format property and as typed it adds all kinds of quotation marks and if I change it around it doesn't work. Thank you for any clarification.

Greg

 

[RV]

Are you saying add ([OldDate],"ddmmmyyyy") to the Format property of the new text box?

What jon98548 meant was, create a query, add a new column which holds the formatted date, OldDate being the column name holding your date....

Another indeed is to set a format on the control (= tektbox) on your form:

dd-mmm-yyyy

Strange that this issue annoys your boss, doesn't he or she have any serious matters to get annoyed 'bout
Or is it just the time of year

RV

 

[Pat Hartman]

day - month name - year is one of the standard named formats. It is called Medium Date.

Formatting the date with the Format() function in the RecordSource query for a form is not a good idea. It makes the date not updatable and it also changes it from a date to a text string. Just set the format property of the control on the form to Medium Date.