Calander problem

1. Senior Member
Join Date
Dec 1969
Posts
157

## Calander problem

2. Senior Member
Join Date
Dec 1969
Posts
1,435

## RE: Calander problem

Argghh! Too much irrelvant code! There&#039;s no danger that I reading all that!<BR><BR>Anyway, assuming that your analysis of the problem is correct, all you need to do is force that day number to 2 digits like this:<BR><BR>strDay = Left("0" & strDay, 2)<BR><BR>Dunc

3. Senior Member
Join Date
Dec 1969
Posts
157

## RE: Calander problem

sorry for all that code.<BR><BR>Okay, so if I do that then won&#039;t it show like this with a date greater than 9 : 010102001 ??

4. Senior Member
Join Date
Dec 1969
Posts
1,435

## RE: Calander problem

D&#039;oh! I should&#039;ve said Right("0" & strDay, 2) - take the day no (1 or 2 characters), add a zero to the start (now 2 or 3 characters) and return the 2 characters on the righthand end. So 10 is still 10, but 1 becomes 01.<BR><BR>Dunc

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•