473,320 Members | 1,695 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Extract single date from date range in same field

1
I have a field called Service Date which contains the following data example:

10/1/2010-11/1/2010

How do I extract each date into 2 separate fields (begin date/end date)?

Thanks!
Feb 1 '12 #1
1 1217
NeoPa
32,556 Expert Mod 16PB
In what environment?

In VBA you'd use the Split() function but in SQL or the design of an object you'd need to use Left() and Mid() in conjunction with InStr(). You need to make your question clearer to save wasting people's time.
Feb 1 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Dennis M. Marks | last post by:
After reading section 15.9.1.1 the ECMAScript Language Specifications I see that the date range for the Date function is +/- 100,000,000 days from 01 Jan 1970. This is called an extrapolated...
1
by: Pooja Raisingani via AccessMonster.com | last post by:
Hello, Can anyone please tell me How to use a select query to extract date from a Datetime field in Access 2000?? Thanks -- Message posted via http://www.accessmonster.com
7
by: AA Arens | last post by:
I have a field "Notes" and I would like to have a button in the vicinity doing the following: It goes to the end of the present text, already filled in the Note-field, performs a and put in the...
0
by: Thanuja | last post by:
Hi please anyone help me. I am using wince API for sending request to server with range header field. I am giving range field as "Range:bytes=0-500"; The problem is request is going to server...
0
by: wolv0014 | last post by:
I'm tring to create a timesheet to track projects and how long people have been working on those projects. For eah date I want to have at least three project boxes, so on the form it would look...
1
by: pchadha20 | last post by:
How to single numeric values from a field in a table which has multiple numeric value in a field of a table.And that table contains thousands of records. Suppose we have a table customer having...
2
by: Luqman | last post by:
Hi, Any Idea how to Display Todays Date in DetailView Template Field while Inserting ? For example: When I click on New Button of DetailView Control, I need to display Today's Date in a...
6
JKing
by: JKing | last post by:
I'm using an update query to update a single field in a table. Table1 is part of my normalized table structure. Table2 is used solely as an import table for raw data which I sort and summarize...
5
by: rekhasc | last post by:
how to store the month and year in the same field in the database using a query....i have a query which stores current month and year in the different fields.... but i want to store in the form...
2
by: p655279 | last post by:
Dear All, Does anyone know how to extract first business date of each month in a DB2 SQL? many many thanks
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.