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?
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?