Hello all
I'm going to try and be brief with my question, please tell me if I have the
wrong group.
We are querying transaction data from a DB3 database application. The dates
are stored as text fields. Each date for example 10/31/03 or October 31st
2003 is stored as 10/31/A3 in the system. My reasoning for this is because
they couldn't solve their Y2K problem or this is their solution to it. All
dates prior to 2000 are stored like actual dates, 10/31/98, 7/4/76, etc.
What we need to do is query the data based on a date range, return a record
set or records including the date in each record and display it on a crystal
report, using the crystal report viewer.
How do I convert the dates information stored like this 10/31/A3 to 10/31/03
? I am extremely new to programming and vb in general, and I am working on
a deadline. This is my only major problem at this time. I need to convert
these dates and store them temporarily in memory so I can pass them on to
the crystal report.
If anyone feels they can help please do, if there is more information needed
please ask. I will do what I can, in the mean time I am studying up on
CDate and similar functions.
Thanks
john
8  3505 
* "John Wildes" <sp******@kissoff.com> scripsit: We are querying transaction data from a DB3 database application. The dates
are stored as text fields. Each date for example 10/31/03 or October 31st
2003 is stored as 10/31/A3 in the system. My reasoning for this is because
they couldn't solve their Y2K problem or this is their solution to it. All
dates prior to 2000 are stored like actual dates, 10/31/98, 7/4/76, etc.
What does "A" stand for? Have a look at 'DateTime.Parse' and
'DateTime.ParseExact' methods.
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
A stands for I believe 200, and the sequence goes something like this.
A3=2003
B3=2013
C3=2023
etc.
My reason for this is because I ended up searching through the FPT files
used in the FoxPro reporting tool and found a listing of conversions that
apparently get read into memory when you run one of their reports. It
actually calls a function called EIGHTTTOD, there is a foxpro function
called TTOD , but I believe they wrote a function called EIGHTTTOD to
convert their dates. I thought about getting REFOX to see how they did it,
but that would be wrong.
I will look into those methods.
Any other suggestions?
john
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:bu************@ID-208219.news.uni-berlin.de... * "John Wildes" <sp******@kissoff.com> scripsit: We are querying transaction data from a DB3 database application. The
dates are stored as text fields. Each date for example 10/31/03 or October
31st 2003 is stored as 10/31/A3 in the system. My reasoning for this is
because they couldn't solve their Y2K problem or this is their solution to it.
All dates prior to 2000 are stored like actual dates, 10/31/98, 7/4/76, etc.
What does "A" stand for? Have a look at 'DateTime.Parse' and
'DateTime.ParseExact' methods.
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
This seems to work:
Private Function Text2Date(ByVal text As String) As Date
' Replace "A" with "200", "B" with "201", "C" with "202" etc
Dim dateString As String = text
dateString = dateString.Replace("A", "200")
dateString = dateString.Replace("B", "201")
dateString = dateString.Replace("C", "202")
dateString = dateString.Replace("D", "203")
dateString = dateString.Replace("E", "204")
dateString = dateString.Replace("F", "205")
dateString = dateString.Replace("G", "206")
dateString = dateString.Replace("H", "207")
dateString = dateString.Replace("I", "208")
dateString = dateString.Replace("J", "209")
' Interpret a 2-digit year as a year between 1900 and 1999
Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo = New
System.Globalization.DateTimeFormatInfo
Dim cal As System.Globalization.Calendar = dateTimeFormat.Calendar
cal.TwoDigitYearMax = 1999
dateTimeFormat.Calendar = cal
' Convert the string
Return Date.Parse(dateString, dateTimeFormat,
Globalization.DateTimeStyles.None)
End Function
/claes
"John Wildes" <sp******@kissoff.com> wrote in message
news:ef**************@tk2msftngp13.phx.gbl... A stands for I believe 200, and the sequence goes something like this.
A3=2003
B3=2013
C3=2023
etc.
My reason for this is because I ended up searching through the FPT files
used in the FoxPro reporting tool and found a listing of conversions that
apparently get read into memory when you run one of their reports. It
actually calls a function called EIGHTTTOD, there is a foxpro function
called TTOD , but I believe they wrote a function called EIGHTTTOD to
convert their dates. I thought about getting REFOX to see how they did
it, but that would be wrong.
I will look into those methods.
Any other suggestions?
john
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:bu************@ID-208219.news.uni-berlin.de... * "John Wildes" <sp******@kissoff.com> scripsit: We are querying transaction data from a DB3 database application. The dates are stored as text fields. Each date for example 10/31/03 or October 31st 2003 is stored as 10/31/A3 in the system. My reasoning for this is because they couldn't solve their Y2K problem or this is their solution to it. All dates prior to 2000 are stored like actual dates, 10/31/98, 7/4/76,
etc.
What does "A" stand for? Have a look at 'DateTime.Parse' and
'DateTime.ParseExact' methods.
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Claes,
With that number of replaces I would consider using a StringBuilder instead.
As the StringBuilder would not be creating 9 extra intermediate strings,
there would be the StringBuilder & the returned String...
Something like:
Private Shared Function Text2Date(ByVal text As String) As Date
' Replace "A" with "200", "B" with "201", "C" with "202" etc
Dim dateString As New System.Text.StringBuilder(text, text.Length *
3)
dateString.Replace("A", "200")
dateString.Replace("B", "201")
dateString.Replace("C", "202")
dateString.Replace("D", "203")
dateString.Replace("E", "204")
dateString.Replace("F", "205")
dateString.Replace("G", "206")
dateString.Replace("H", "207")
dateString.Replace("I", "208")
dateString.Replace("J", "209")
' Interpret a 2-digit year as a year between 1900 and 1999
Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo = New
System.Globalization.DateTimeFormatInfo
Dim cal As System.Globalization.Calendar = dateTimeFormat.Calendar
cal.TwoDigitYearMax = 1999
dateTimeFormat.Calendar = cal
' Convert the string
Return Date.Parse(dateString.ToString(), dateTimeFormat,
Globalization.DateTimeStyles.None)
End Function
"Claes Bergefall" <cl********************@frontec.se> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... This seems to work:
Private Function Text2Date(ByVal text As String) As Date
' Replace "A" with "200", "B" with "201", "C" with "202" etc
Dim dateString As String = text
dateString = dateString.Replace("A", "200")
dateString = dateString.Replace("B", "201")
dateString = dateString.Replace("C", "202")
dateString = dateString.Replace("D", "203")
dateString = dateString.Replace("E", "204")
dateString = dateString.Replace("F", "205")
dateString = dateString.Replace("G", "206")
dateString = dateString.Replace("H", "207")
dateString = dateString.Replace("I", "208")
dateString = dateString.Replace("J", "209")
' Interpret a 2-digit year as a year between 1900 and 1999
Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo = New
System.Globalization.DateTimeFormatInfo
Dim cal As System.Globalization.Calendar = dateTimeFormat.Calendar
cal.TwoDigitYearMax = 1999
dateTimeFormat.Calendar = cal
' Convert the string
Return Date.Parse(dateString, dateTimeFormat,
Globalization.DateTimeStyles.None)
End Function
/claes
"John Wildes" <sp******@kissoff.com> wrote in message
news:ef**************@tk2msftngp13.phx.gbl... A stands for I believe 200, and the sequence goes something like this.
A3=2003
B3=2013
C3=2023
etc.
My reason for this is because I ended up searching through the FPT files
used in the FoxPro reporting tool and found a listing of conversions
that apparently get read into memory when you run one of their reports. It
actually calls a function called EIGHTTTOD, there is a foxpro function
called TTOD , but I believe they wrote a function called EIGHTTTOD to
convert their dates. I thought about getting REFOX to see how they did
it, but that would be wrong.
I will look into those methods.
Any other suggestions?
john
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:bu************@ID-208219.news.uni-berlin.de... * "John Wildes" <sp******@kissoff.com> scripsit:
> We are querying transaction data from a DB3 database application.
The dates > are stored as text fields. Each date for example 10/31/03 or
October 31st > 2003 is stored as 10/31/A3 in the system. My reasoning for this is
because > they couldn't solve their Y2K problem or this is their solution to
it. All > dates prior to 2000 are stored like actual dates, 10/31/98, 7/4/76,
etc.
What does "A" stand for? Have a look at 'DateTime.Parse' and
'DateTime.ParseExact' methods.
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
What happens is I need to return a set of records based on a Customer Code
and a Date Range. I have code in place to select the records I need based
on customer code, and what I am working at now is how do I filter these
records on a date range, which means I would have to convert the date from
(ex. 01/01/A4) to (ex. 01/01/04) in place before it is returned to the
listview that I have created, and then pass the data on in the correct
format i.e. 01/01/04 to the crystal report. The data doesn't have to be
saved anywhere and we do not need to update the system. Any idea how I
would do that? This is primarily to create a statement report.
Thanks for any input.
john
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl... Claes,
With that number of replaces I would consider using a StringBuilder
instead. As the StringBuilder would not be creating 9 extra intermediate strings,
there would be the StringBuilder & the returned String...
Something like:
Private Shared Function Text2Date(ByVal text As String) As Date
' Replace "A" with "200", "B" with "201", "C" with "202" etc
Dim dateString As New System.Text.StringBuilder(text, text.Length
* 3)
dateString.Replace("A", "200")
dateString.Replace("B", "201")
dateString.Replace("C", "202")
dateString.Replace("D", "203")
dateString.Replace("E", "204")
dateString.Replace("F", "205")
dateString.Replace("G", "206")
dateString.Replace("H", "207")
dateString.Replace("I", "208")
dateString.Replace("J", "209")
' Interpret a 2-digit year as a year between 1900 and 1999
Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo =
New System.Globalization.DateTimeFormatInfo
Dim cal As System.Globalization.Calendar = dateTimeFormat.Calendar
cal.TwoDigitYearMax = 1999
dateTimeFormat.Calendar = cal
' Convert the string
Return Date.Parse(dateString.ToString(), dateTimeFormat,
Globalization.DateTimeStyles.None)
End Function
"Claes Bergefall" <cl********************@frontec.se> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... This seems to work:
Private Function Text2Date(ByVal text As String) As Date
' Replace "A" with "200", "B" with "201", "C" with "202" etc
Dim dateString As String = text
dateString = dateString.Replace("A", "200")
dateString = dateString.Replace("B", "201")
dateString = dateString.Replace("C", "202")
dateString = dateString.Replace("D", "203")
dateString = dateString.Replace("E", "204")
dateString = dateString.Replace("F", "205")
dateString = dateString.Replace("G", "206")
dateString = dateString.Replace("H", "207")
dateString = dateString.Replace("I", "208")
dateString = dateString.Replace("J", "209")
' Interpret a 2-digit year as a year between 1900 and 1999
Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo = New
System.Globalization.DateTimeFormatInfo
Dim cal As System.Globalization.Calendar = dateTimeFormat.Calendar
cal.TwoDigitYearMax = 1999
dateTimeFormat.Calendar = cal
' Convert the string
Return Date.Parse(dateString, dateTimeFormat,
Globalization.DateTimeStyles.None)
End Function
/claes
"John Wildes" <sp******@kissoff.com> wrote in message
news:ef**************@tk2msftngp13.phx.gbl... A stands for I believe 200, and the sequence goes something like this.
A3=2003
B3=2013
C3=2023
etc.
My reason for this is because I ended up searching through the FPT
files used in the FoxPro reporting tool and found a listing of conversions that apparently get read into memory when you run one of their reports. It
actually calls a function called EIGHTTTOD, there is a foxpro function
called TTOD , but I believe they wrote a function called EIGHTTTOD to
convert their dates. I thought about getting REFOX to see how they
did it, but that would be wrong.
I will look into those methods.
Any other suggestions?
john
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:bu************@ID-208219.news.uni-berlin.de...
> * "John Wildes" <sp******@kissoff.com> scripsit:
> > We are querying transaction data from a DB3 database application. The dates
> > are stored as text fields. Each date for example 10/31/03 or October 31st
> > 2003 is stored as 10/31/A3 in the system. My reasoning for this
is because
> > they couldn't solve their Y2K problem or this is their solution to it. All
> > dates prior to 2000 are stored like actual dates, 10/31/98,
7/4/76, etc. >
> What does "A" stand for? Have a look at 'DateTime.Parse' and
> 'DateTime.ParseExact' methods.
>
> --
> Herfried K. Wagner [MVP]
> <http://www.mvps.org/dotnet>
John,
If I am following your question, I would strongly suggest you correct the
database itself.
Is the database itself going to stay FoxPro, or are you converting it to
another DB?
If you are converting the database to another DB, then I would change the
column to a real date field at that time.
If you are not converting to something other then FoxPro, I would consider
defining a view or SP in FoxPro (does FoxPro support stored procedures?)
that presented a real date to your program.
How many rows are we talking about, you could retrieve all the rows into a
DataTable, add an extra column for the date, run Claes's routine for each
row updating the extra column, then do a DataTable.Select on this extra
column. Of course if the desired rows is significantly less then the number
of rows in the table, this is probably more pain then gain...
Alternatively you could create a pseudo date that you use to compare against
the database..
Mostly, I would strongly suggest you correct the database!!!
Note: I have not really used Foxpro, so I'm not sure if a stored procedure
is supported...
Hope this helps
Jay
"John Wildes" <sp******@kissoff.com> wrote in message
news:ul**************@tk2msftngp13.phx.gbl... What happens is I need to return a set of records based on a Customer Code
and a Date Range. I have code in place to select the records I need based
on customer code, and what I am working at now is how do I filter these
records on a date range, which means I would have to convert the date from
(ex. 01/01/A4) to (ex. 01/01/04) in place before it is returned to the
listview that I have created, and then pass the data on in the correct
format i.e. 01/01/04 to the crystal report. The data doesn't have to be
saved anywhere and we do not need to update the system. Any idea how I
would do that? This is primarily to create a statement report.
Thanks for any input.
john
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl... Claes,
With that number of replaces I would consider using a StringBuilder instead. As the StringBuilder would not be creating 9 extra intermediate strings,
there would be the StringBuilder & the returned String...
Something like:
Private Shared Function Text2Date(ByVal text As String) As Date
' Replace "A" with "200", "B" with "201", "C" with "202" etc
Dim dateString As New System.Text.StringBuilder(text,
text.Length * 3)
dateString.Replace("A", "200")
dateString.Replace("B", "201")
dateString.Replace("C", "202")
dateString.Replace("D", "203")
dateString.Replace("E", "204")
dateString.Replace("F", "205")
dateString.Replace("G", "206")
dateString.Replace("H", "207")
dateString.Replace("I", "208")
dateString.Replace("J", "209")
' Interpret a 2-digit year as a year between 1900 and 1999
Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo =
New System.Globalization.DateTimeFormatInfo
Dim cal As System.Globalization.Calendar =
dateTimeFormat.Calendar cal.TwoDigitYearMax = 1999
dateTimeFormat.Calendar = cal
' Convert the string
Return Date.Parse(dateString.ToString(), dateTimeFormat,
Globalization.DateTimeStyles.None)
End Function
"Claes Bergefall" <cl********************@frontec.se> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... This seems to work:
Private Function Text2Date(ByVal text As String) As Date
' Replace "A" with "200", "B" with "201", "C" with "202" etc
Dim dateString As String = text
dateString = dateString.Replace("A", "200")
dateString = dateString.Replace("B", "201")
dateString = dateString.Replace("C", "202")
dateString = dateString.Replace("D", "203")
dateString = dateString.Replace("E", "204")
dateString = dateString.Replace("F", "205")
dateString = dateString.Replace("G", "206")
dateString = dateString.Replace("H", "207")
dateString = dateString.Replace("I", "208")
dateString = dateString.Replace("J", "209")
' Interpret a 2-digit year as a year between 1900 and 1999
Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo =
New System.Globalization.DateTimeFormatInfo
Dim cal As System.Globalization.Calendar = dateTimeFormat.Calendar
cal.TwoDigitYearMax = 1999
dateTimeFormat.Calendar = cal
' Convert the string
Return Date.Parse(dateString, dateTimeFormat,
Globalization.DateTimeStyles.None)
End Function
/claes
"John Wildes" <sp******@kissoff.com> wrote in message
news:ef**************@tk2msftngp13.phx.gbl...
> A stands for I believe 200, and the sequence goes something like
this. >
> A3=2003
> B3=2013
> C3=2023
>
> etc.
>
> My reason for this is because I ended up searching through the FPT files > used in the FoxPro reporting tool and found a listing of conversions
that > apparently get read into memory when you run one of their reports.
It > actually calls a function called EIGHTTTOD, there is a foxpro
function > called TTOD , but I believe they wrote a function called EIGHTTTOD
to > convert their dates. I thought about getting REFOX to see how they did it,
> but that would be wrong.
>
> I will look into those methods.
>
> Any other suggestions?
> john
>
>
> "Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in
message > news:bu************@ID-208219.news.uni-berlin.de...
> > * "John Wildes" <sp******@kissoff.com> scripsit:
> > > We are querying transaction data from a DB3 database
application. The > dates
> > > are stored as text fields. Each date for example 10/31/03 or
October > 31st
> > > 2003 is stored as 10/31/A3 in the system. My reasoning for this is > because
> > > they couldn't solve their Y2K problem or this is their solution
to it. > All
> > > dates prior to 2000 are stored like actual dates, 10/31/98,
7/4/76, etc.
> >
> > What does "A" stand for? Have a look at 'DateTime.Parse' and
> > 'DateTime.ParseExact' methods.
> >
> > --
> > Herfried K. Wagner [MVP]
> > <http://www.mvps.org/dotnet>
>
>
Jay,
I wish that I could correct the database, but it the application that uses
it is written by a third party, who admits that this was their lazy way of
solving the Y2K problem rather than changing the fields in their data base
to support date format.
(Anyone ever hear of "The Agency Manager" by Applied Systems ???? this is
the app that I am talking about)
The database itself is DB3 and I am using a FoxPro driver to access it
because the DB3 driver takes forever to return a simple query. There are
only 70,000 records in the transact dbf file, and I am only looking at a
smaller subset of those records, possibly no more than 1000.
FoxPro does support stored procedures based on a FoxPro DBC file which
basically is a file that links DBFs. If I add the tables from this
application to the FoxPro DBC it corrupts them so the application cannot use
them. Using a stored procedure might get really messy.
I will look into creating a datatable, with an additional row to convert the
proper date. This isn't more hassle than it's worth for me. We need to get
this done, and I am willing to try anything right now.
More importantly, thanks for all the help. I will let you know how this
comes out.
john
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:en**************@TK2MSFTNGP09.phx.gbl... John,
If I am following your question, I would strongly suggest you correct the
database itself.
Is the database itself going to stay FoxPro, or are you converting it to
another DB?
If you are converting the database to another DB, then I would change the
column to a real date field at that time.
If you are not converting to something other then FoxPro, I would consider
defining a view or SP in FoxPro (does FoxPro support stored procedures?)
that presented a real date to your program.
How many rows are we talking about, you could retrieve all the rows into a
DataTable, add an extra column for the date, run Claes's routine for each
row updating the extra column, then do a DataTable.Select on this extra
column. Of course if the desired rows is significantly less then the
number of rows in the table, this is probably more pain then gain...
Alternatively you could create a pseudo date that you use to compare
against the database..
Mostly, I would strongly suggest you correct the database!!!
Note: I have not really used Foxpro, so I'm not sure if a stored procedure
is supported...
Hope this helps
Jay
"John Wildes" <sp******@kissoff.com> wrote in message
news:ul**************@tk2msftngp13.phx.gbl... What happens is I need to return a set of records based on a Customer
Code and a Date Range. I have code in place to select the records I need
based on customer code, and what I am working at now is how do I filter these
records on a date range, which means I would have to convert the date
from (ex. 01/01/A4) to (ex. 01/01/04) in place before it is returned to the
listview that I have created, and then pass the data on in the correct
format i.e. 01/01/04 to the crystal report. The data doesn't have to be
saved anywhere and we do not need to update the system. Any idea how I
would do that? This is primarily to create a statement report.
Thanks for any input.
john
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
message news:%2****************@TK2MSFTNGP12.phx.gbl... Claes,
With that number of replaces I would consider using a StringBuilder instead. As the StringBuilder would not be creating 9 extra intermediate
strings, there would be the StringBuilder & the returned String...
Something like:
Private Shared Function Text2Date(ByVal text As String) As Date
' Replace "A" with "200", "B" with "201", "C" with "202" etc
Dim dateString As New System.Text.StringBuilder(text, text.Length * 3)
dateString.Replace("A", "200")
dateString.Replace("B", "201")
dateString.Replace("C", "202")
dateString.Replace("D", "203")
dateString.Replace("E", "204")
dateString.Replace("F", "205")
dateString.Replace("G", "206")
dateString.Replace("H", "207")
dateString.Replace("I", "208")
dateString.Replace("J", "209")
' Interpret a 2-digit year as a year between 1900 and 1999
Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo
= New System.Globalization.DateTimeFormatInfo
Dim cal As System.Globalization.Calendar = dateTimeFormat.Calendar cal.TwoDigitYearMax = 1999
dateTimeFormat.Calendar = cal
' Convert the string
Return Date.Parse(dateString.ToString(), dateTimeFormat,
Globalization.DateTimeStyles.None)
End Function
"Claes Bergefall" <cl********************@frontec.se> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
> This seems to work:
>
> Private Function Text2Date(ByVal text As String) As Date
> ' Replace "A" with "200", "B" with "201", "C" with "202" etc
> Dim dateString As String = text
> dateString = dateString.Replace("A", "200")
> dateString = dateString.Replace("B", "201")
> dateString = dateString.Replace("C", "202")
> dateString = dateString.Replace("D", "203")
> dateString = dateString.Replace("E", "204")
> dateString = dateString.Replace("F", "205")
> dateString = dateString.Replace("G", "206")
> dateString = dateString.Replace("H", "207")
> dateString = dateString.Replace("I", "208")
> dateString = dateString.Replace("J", "209")
>
> ' Interpret a 2-digit year as a year between 1900 and 1999
> Dim dateTimeFormat As System.Globalization.DateTimeFormatInfo = New > System.Globalization.DateTimeFormatInfo
> Dim cal As System.Globalization.Calendar =
dateTimeFormat.Calendar > cal.TwoDigitYearMax = 1999
> dateTimeFormat.Calendar = cal
>
> ' Convert the string
> Return Date.Parse(dateString, dateTimeFormat,
> Globalization.DateTimeStyles.None)
> End Function
>
> /claes
>
>
> "John Wildes" <sp******@kissoff.com> wrote in message
> news:ef**************@tk2msftngp13.phx.gbl...
> > A stands for I believe 200, and the sequence goes something like
this. > >
> > A3=2003
> > B3=2013
> > C3=2023
> >
> > etc.
> >
> > My reason for this is because I ended up searching through the FPT
files > > used in the FoxPro reporting tool and found a listing of
conversions that
> > apparently get read into memory when you run one of their reports. It > > actually calls a function called EIGHTTTOD, there is a foxpro function > > called TTOD , but I believe they wrote a function called EIGHTTTOD to > > convert their dates. I thought about getting REFOX to see how
they did > it,
> > but that would be wrong.
> >
> > I will look into those methods.
> >
> > Any other suggestions?
> > john
> >
> >
> > "Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message > > news:bu************@ID-208219.news.uni-berlin.de...
> > > * "John Wildes" <sp******@kissoff.com> scripsit:
> > > > We are querying transaction data from a DB3 database application. The
> > dates
> > > > are stored as text fields. Each date for example 10/31/03 or
October
> > 31st
> > > > 2003 is stored as 10/31/A3 in the system. My reasoning for
this is > > because
> > > > they couldn't solve their Y2K problem or this is their
solution to it.
> > All
> > > > dates prior to 2000 are stored like actual dates, 10/31/98,
7/4/76, > etc.
> > >
> > > What does "A" stand for? Have a look at 'DateTime.Parse' and
> > > 'DateTime.ParseExact' methods.
> > >
> > > --
> > > Herfried K. Wagner [MVP]
> > > <http://www.mvps.org/dotnet>
> >
> >
>
>
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...
|
by: Peter Row |
last post by:
Hi all,
Here is my problem:
I have a SQL Server 2000 DB with various NVarChar, NText fields in its
tables.
For some stupid reason the data was inserted into these fields in UTF8
encoding.
...
|
by: deko |
last post by:
After importing text date fields, the dates look like this:
12/31/2003 8:00:00 AM
I'm having trouble working with these dates with Date(), Now(), etc, --
does not seem to match these dates....
|
by: Sandy Fleming |
last post by:
What is the easiest way to force Access to read a date in a specific
format?
I have an application that imports a delimited text file with a date
field in the format "mm/dd/yyyy".
I've...
|
by: Riley DeWiley |
last post by:
I have an UPDATE query that is always setting 0 records. When I cut and
paste the SQL into Access and use it, it fails in the same way unless I
coerce the date fields to be '=now()', in which case...
|
by: Annie D via AccessMonster.com |
last post by:
Problem!
I have a series of CSV files that I am bringing in to Access, contained
within each of them are 6 date fields, however, they are not being recognized
as dates…this is a big problem!...
|
by: dhnriverside |
last post by:
Hi peeps
I have a datepicker control that's providing dates in the format dd/mm/yyyy
(UK).
I want to convert this to "yyyy-mm-dd" to store as a text field in my
database (had lots of problems...
|
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: Beckster6701 |
last post by:
I have a MSAccess database that is linked to a SQL server. I cannot
change the SQL server datatype as I am not the only one that uses the
database. I'm trying to convert the text field to a valid...
|
by: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
|
by: Naresh1 |
last post by:
What is WebLogic Admin Training?
WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
|
by: BLUEPANDA |
last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
|
by: Johno34 |
last post by:
I have this click event on my form. It speaks to a Datasheet Subform
Private Sub Command260_Click()
Dim r As DAO.Recordset
Set r = Form_frmABCD.Form.RecordsetClone
r.MoveFirst
Do
If...
|
by: ezappsrUS |
last post by:
Hi,
I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
|
by: jack2019x |
last post by:
hello, Is there code or static lib for hook swapchain present?
I wanna hook dxgi swapchain present for dx11 and dx9.
|
by: DizelArs |
last post by:
Hi all)
Faced with a problem, element.click() event doesn't work in Safari browser.
Tried various tricks like emulating touch event through a function:
let clickEvent = new Event('click', {...
| |
