Concatenate & Format 3 Fields

J

Jani

I have three fields that I want to add together using a query. The first
field should have 4 characters (no problem), the second field in the table
will be either 1 or 2 characters but must be displayed as two (if <10 than
preceds with a 0 - 1 must be 01), and the same for the third field (if 8 must
be 08). This is my formula:
Inv Date: [year] & Format([month],"MM") & Format([day],"DD").
The result is correct for the year, the month is always displaying as 01,
and the day is one day earlier. So if the result should be 20080709, the
result is 20080108; if the result should be 20081108, the result displayed is
20080107. Would someone please help with how this can be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate Age problem date notation european american format 2
Concatenate Text Fields to Date Field 5
Date Format in a Query 5
Change a datefield to the first day in the given month? 5
Week, monthly, quarterly 2
dates in table 2 fields need to be one field I can sort by date on 5
Help needed on zero filling the left and middle and concatenate 0
Group dates 1

Top