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 |
|
pcjammer
Starting Member
1 Post |
 Posted - 2007-08-29 : 16:44:58
|
| How can I convert a Ms Access DateSerial function to specify a date dynamic for the current year and select a specific date? i.e. Access version DateSerial(Year(date()),1,31) for Current year and Jan. 31st. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-29 : 16:55:07
|
| Year(Getdate() ) will give you current year. Not sure what DateSerial does.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
DateSerial