|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
I wrote a program in Access 2k that returns a start date for a column to be filled in, starting with todays date and moving forward 2 weeks...On my laptop the program works fine, but once I move it to a server it skips todays date and moves todays data in tomorrows column etc, until data doubles up on the last day...the date/time stamps are identical on both the server and the laptop...Does anyone know how I can solve this problem?
|
|
#2
|
|||
|
|||
|
Try using the Dateserial function in this sort of operation
example (Add 21 years to current date) DateSerial(Year(now()+21,Month(now()),Day(now()) |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Date Wrong |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|