date formatting

[malcolmmabe]

i'm having trouble merging a date into publisher. i think
the problem is the data formatting(i need it in english
format) i've tried the code format([date],"dd/mm/yy") but
this only works upto and including the 12th of the month,
must be a bug in access. anyway, what would the code be
for formatting the date 13/2/04 into 13 february 2004?

 

[Andrew Smith]

I doubt there is a bug like this in Access. It's probably that your date
field does not contain what you think it does! Check the regional settings
on your PC are set for the UK date format, and then open the table that
contains your dates in datasheet view, and check that the dates are correct.

If you want to test the Format function, open the intermediate window and
type in the following:

?format(dateserial(2004,2,15),"dd/mm/yyyy")

This should print "15/02/2004" in the intermediate window. If it does then
the format function is working as it should.

For the second question, the code would be format([date],"dd mmmm yyyy"),
assuming you want a captial letter for the start of the month. If you really
want it all lower case as written, then you would put
LCase(Format([date],"dd mmmm yyyy")).

It's probably a good idea to rename your field to something other than
"date" as this can cause problems. (Having said that I've got several
databases with fields called "date" that I created before I found out that
this could cause problems, and they all work fine).