Dates

  • Thread starter Thread starter Dates
  • Start date Start date
D

Dates

If I have my field in a table set up 4/1/2003 and I want
to update the fields to read : 1 day of April in the year
2003, how can I do this?

Do I go to update query?
 
If I have my field in a table set up 4/1/2003 and I want
to update the fields to read : 1 day of April in the year
2003, how can I do this?

Do I go to update query?
Click to expand...

If the field is a valid date/time entry, it's not necessary to make
any data changes.
I assume you wish to display this in a report.
If so, just enter:
d" day of "mmmm" in the year "yyyy
on the control's Format Property line.

If you wanted to write
1st day of April in the year 2003
you would need to write a user defined function to get the ordinal
ending value (st, nd,rd,th).
If you need help getting the ordinal ending, post back.
 
In the design view of the query I put the format as you
suggested. It worked in the datasheet view perfectly.
Now I am trying to perform a mail merge and it is giving
me 4/1/2003. Am I missing something?
 
In the design view of the query I put the format as you
suggested. It worked in the datasheet view perfectly.
Now I am trying to perform a mail merge and it is giving
me 4/1/2003. Am I missing something?
Click to expand...


Ah, but you never said you were doing a Mail Merge to Word.
My recommendation was for use in an Access Report.

Perhaps this will work in the query.
NewDateLayout: Format([DateField],"d"" day of ""mmmm"" in the year of
""yyyy")
Male sure the quotes are doubled up where indicated.

Use this NewDateLayout field in the mail merge, not the [DateField].
 
Back
Top