I have a database I want to install on another computer. I originally did it on my original computer and want to put it on another computer for others to use.
The problem lies that when I move over the database to another computer, running the same software, operating system my date calculations go weird on me.
Originally this is how things are setup
[Delivery Date] + 5 - Set to Short Date/Time
Rather than add 5 days as it normally does on the original computer I programmed this on, it adds +5 (and more) to the month. It also reformats the date to some weird format 19th month?!
For the life of me, I don't know what is going on. Can anyone help me identify the problem?
Gary