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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert number to date

Status
Not open for further replies.
douggy

douggy

Technical User
Jan 18, 2001
78
0
0
GB
Hi there,

I have to convert the following number format to a date. ie something I can query on for where a year month between x and y.

Number is in following format "200801" YYYYMM

Thanks for your help in advance.

Mark
 
Sort by date Sort by votes


hi,
Code: 
EndOfMoDte: DateSerial(Mid("200801",1,4),Mid("200801",4,2)+1,0)
StrtOfMoDte: DateSerial(Mid("200801",1,4),Mid("200801",4,2),1)


Skip,
[sup][glasses]Don't let the Diatribe...
talk you to death![tongue][/sup][sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
294
serino
serino
monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
142
Andrzejek
Andrzejek
datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
140
dhookom
dhookom
JayRo71
  • Locked
  • Question
Unable to sort date field
Replies
4
Views
77
JayRo71
JayRo71
caykamanj1966
  • Locked
  • Question
Get Yesterday's Date
Replies
1
Views
63
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top