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

Substr function: grab yr from the 20030101

Status
Not open for further replies.
d1004

d1004

Programmer
May 9, 2002
78
US
Is there a function that could help me separate out the following date into year & month. The date is stored as 20030101 rather than 01/01/2003
 
Sort by date Sort by votes
To get the year as a value from the string "20030101", use:
Val(Left([YourField],4))
The month would be
Val(Mid([YourField],5,2))

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
277
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
394
TheresAlwaysAWay
TheresAlwaysAWay
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
484
lameid
lameid
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
343
strongm
strongm
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
724
combo
combo

Part and Inventory Search

Sponsor

Back
Top