Calendar Day Wrong

[prawln]

Hey guys,



I've been looking at a sample database that is used for making appointments etc. When I have my Regional Settings on my computer set to short date (dd/mm/yyyy) then in the ms access calendar it shows the date correct but the actual days are 2 days out. Picture attached called Wrong.

Then if i set the regional settings to shortdate (mm/dd/yyyy) it makes the date and days etc all correct. Attached picture called right. I have also attached the sample to.

Any help would be so awesome.

Thanks guys!

[RuralGuy]

Have you reviewed this link yet? http://allenbrowne.com/ser-36.html

[prawln]

Cheers Ruralguy!

I've had abit of a play and changed some of the VB to be DD/MM/YYYY but it still seems to be wrong.

When I was mucking around I realised when I have the reigonal settings set to short date (dd/mm/yyyy) the calendar is exactly 1 year off. So if I go to 2013 then the date and the day all matches up!

Im slightly new to this sort of thing so any help would be good.

[prawln]

Solved the issue

In VB it had: strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)
When it should have been: strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)

Thanks for the link anyways mate, It was good to read!

[boblarson]

Probably, the better code would have used DateSerial instead.

[RuralGuy]

Once you know what to look for it is much better when you solve it yourself. Thanks for posting back with your success and solution.