My DB is Access 2000 based "possibly written in 2002" and I have to send and
receive update files, ported to a UNIX server by FTP, DB unknown.
The file content uses a fixed length string, zero filled left.
ie;
001332001695001 995040601040630
where,
001332,001695,0 01995,040601,04 0630
Filename: Newprice.txt - detail record
Field Name
Data Type
Description
OLCC Item Code
Numeric(6,0)
Zero filled to the left.
New Price
Numeric(6,2)
Old Price
Numeric(6,2)
Start Date
Numeric(6,0)
Format YYYYMMDD. Beginning date when new price takes effect.
End Date
Numeric(6,0)
Format YYYYMMDD. Last date when new price no longer applies.
My problem is that Microsoft DB format does not accept dates without
delimiters ie; / / or , , or _ _
The same goes for a similar time format in another file where time is hhmm
as opposed to MS hh:mm
How can I convert or get Access to import and export this format.
ie: yymmdd=040520=0 4/05/20
and 04/05/20=040520
I have to go both ways.
I hope I have provided enough information and appreciate any help you can
provide.
Bruce "Luckydog" 1 3411
Hi Bruce.
Parse the text field with Mid(), and generate the dates with DateSerial()
If the text field is called "d", and contains strings of numbers
representing yymmdd, this example pulls out the 2nd date:
DateSerial(Mid([d], 7, 2), Mid([d], 9, 2), Mid([d], 11, 2))
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bruce Cushman" <cu*****@hevane t.com> wrote in message
news:20******** ***********@new s.newsreader.co m... My DB is Access 2000 based "possibly written in 2002" and I have to send
and receive update files, ported to a UNIX server by FTP, DB unknown. The file content uses a fixed length string, zero filled left. ie;
001332001695001 995040601040630
where, 001332,001695,0 01995,040601,04 0630 Filename: Newprice.txt - detail record
Field Name Data Type Description
OLCC Item Code Numeric(6,0) Zero filled to the left.
New Price Numeric(6,2)
Old Price Numeric(6,2)
Start Date Numeric(6,0) Format YYYYMMDD. Beginning date when new price takes effect.
End Date Numeric(6,0) Format YYYYMMDD. Last date when new price no longer applies. My problem is that Microsoft DB format does not accept dates without delimiters ie; / / or , , or _ _ The same goes for a similar time format in another file where time is hhmm as opposed to MS hh:mm How can I convert or get Access to import and export this format.
ie: yymmdd=040520=0 4/05/20 and 04/05/20=040520
I have to go both ways.
I hope I have provided enough information and appreciate any help you can provide.
Bruce "Luckydog" This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: praba kar |
last post by:
Dear All,
I have doubt regarding date string to time
conversion function. In Python I cannot find flexible
date string conversion function like php strtotime. I
try to use following type
function
1) parsedate function failed if a date string
like below format "16-MAY-2005 01:26"
2)parsedate_tz function also failed if a date string
|
by: Niall Porter |
last post by:
Hi all,
I'm building an ASP app on a Windows 2000/IIS machine which interfaces
with our SQL Server 2000 database via OLE DB.
Since we're based in the UK I want the users to be able to type in
dates in UK date format to input into the database. In Enterprise
Manager on the SQL Server I can manually enter a record into a table
and just type in a UK date (MM/DD/YYYY e.g. 25/12/2004) and it accepts
it happily.
|
by: Edward Mitchell |
last post by:
I have a number of DateTimePicker controls, some set to dates, some set to a
format of Time. The controls are all embedded in dialogs. I created the
controls by dragging the DateTime picker from the Toolbox and then set the
Format property appropriately.
I have noticed that sometimes the Time format will reset spontaneously to
Short Date. I looked at the .rc file and found that the usual form for a
Short Date is as follows:
CONTROL ...
|
by: Khurram |
last post by:
I have a problem while inserting time value in the datetime Field.
I want to Insert only time value in this format (08:15:39) into the SQL
Date time Field.
I tried to many ways, I can extract the value in timeonly format by using
this command
Format(now,"HH:mm:ss")
But when I insert it into the Sql Server database, it embadded date value
with it.
the output looks like that "01/01/1900 08:59:00" in that case time is
|
by: z. f. |
last post by:
HI,
i have string in format
dd/mm/yyyyy hh:mm:ss
and giving this as an input to DateTime.Parse gives a string was not
recognized as a valid date time format string error.
how do i make the parse method to accept formating that i need.
if i do console.writeLine DateTime.Now.ToString it gives the format:
YYYY-MM-DD HH:MM:SS
TIA, Z.
| |
by: Assimalyst |
last post by:
Hi,
I have a working script that converts a dd/mm/yyyy text box date entry
to yyyy/mm/dd and compares it to the current date, giving an error
through an asp.net custom validator, it is as follows:
function doDateCheckNow(source, args)
{
var oDate = document.getElementById(source.controltovalidate); //
dd/mm/yyyy
|
by: user |
last post by:
Hi,
Let's say I have 2 dates in the b/m format:
Date 1 and date 2
How do I check whether Date2 is later than Date 1?
Date1. 21-Nov-2006 09:00:00 PM
|
by: bruce.dodds |
last post by:
Access seems to be handling a date string conversion inconsistently in
an append query.
The query converts a YYYYMM string into a date, using the following
function:
CDate(Right(,2) & "/1/" &
Left(,4))
I entered the string "200715" in a record to test an error condition.
|
by: RN1 |
last post by:
A TextBox displays the current date (in dd/mm/yyyy format) & time when
a user comes to a page (e.g. 15/10/2008 1:36:39 PM). To convert the
date into international format so that the remote server doesn't
generate any error, this is what I am doing:
---------------------------
Dim strSDate As String
Dim strSTime As String
Dim strStartDT As String
Dim strSDateTime As String
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |