Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reversing Datepart?

Status
Not open for further replies.
nickjar2

nickjar2

Programmer
Jun 20, 2001
778
US
I can use this:

DatePart("ww",[some date],2,3) and it could give me 36. But is there a function that will turn this 36 back into a date? Nick (Everton Rool OK!)
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

DonP
  • Locked
  • Question
Reversing SOME Names 1
Replies
2
Views
53
DonP
DonP
SilentAiche
  • Locked
  • Question
Reversing Name Order in Report
Replies
19
Views
389
SilentAiche
SilentAiche
pctechguy
  • Locked
  • Question
Datepart function pulling lastweek of a month
Replies
14
Views
263
BobJacksonNCI
BobJacksonNCI
JJman
  • Locked
  • Question
DatePart to Extract Time...
Replies
2
Views
36
JJman
JJman
ferindojr
  • Locked
  • Question
Reversing Acess 2000 Startup options 1
Replies
1
Views
38
jebry
jebry

Part and Inventory Search

Sponsor

Back
Top