Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naresh82
Starting Member
1 Post |
 Posted - 2003-03-27 : 09:19:32
|
| i need a built-in function that minus sysdate from gven date like diff(sysdate,'12-jan-02'). i dont know the function which minus sysdate from given date .i only know the format . |
|
|
Peter Dutch
Posting Yak Master
127 Posts |
Posted - 2003-03-27 : 09:22:52
|
| DateDiff ("[interval]", Date(), '01-01-2003')check the Access help for possible values of [interval] |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-03-27 : 09:24:03
|
| Read Access help about the dateDiff() function.Or, you can just subtract:Days = Date() - [Any date you want]That will return the number of days different between the two dates.- Jeff |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-03-27 : 09:24:45
|
| Sorry Pete -- you got me by like 1 second!- Jeff |
|
|
|
|
|
|
how to minus sysdate from given date using functio