Mark Forums Read

String to Date Conversion Error

Go Back

comp.databases.paradox comp.databases.paradox

Reply

Page 1 of 6

1

#1

Old

Joseph Misko

Posts: n/a

String to Date Conversion Error - 12-18-2008 , 03:48 PM

I have a script that has been working for years. It is on a machine that
needed some rehaul due to a virus (I did not do the rehaul). Everything is
clean and otherwise working as before for a few weeks now.

In the script, I build a string based on criteria that is later converted to
a date. In this case the string is "07/01/2008" and I am getting the
following errors on the stack in Paradox X3.

(1) Date:Proc

ate: The value of the parameter, 'value', is not legal.
Cannot convert parameter to a date.

(2) Could not convert data of type 'String' to type Date'. The types are
mismatched or the values are incompatible.

(3) Invalid character: 07/01/20"0"8

So, it obviously does not like the third digit in a four digit year, but I
have never had this problem before with four digit years. I have already
verified that the BDE is set to FOURDIGITYEAR (TRUE). Must be some other
mysterious setting.

Has anyone seen this before?

Many thanks, --Joe

P. S. I guess there is a bit of Paradox trivia in message #2. I did type it
correctly and the first single quote before Date is missing. Guess that
coding/formatting issue was never picked up.

Reply With Quote

#2

Old

Tony McGuire

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 03:59 PM

Joseph Misko wrote:

Quote:

In the script, I build a string based on criteria that is later
converted to a date. In this case the string is "07/01/2008" and I am
getting the following errors on the stack in Paradox X3.

(1) Date:Proc

ate: The value of the parameter, 'value', is not legal.
Cannot convert parameter to a date.

(2) Could not convert data of type 'String' to type Date'. The types are
mismatched or the values are incompatible.

(3) Invalid character: 07/01/20"0"8

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Reply With Quote

#3

Old

Tony McGuire

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 03:59 PM

Joseph Misko wrote:

Quote:

In the script, I build a string based on criteria that is later
converted to a date. In this case the string is "07/01/2008" and I am
getting the following errors on the stack in Paradox X3.

(1) Date:Proc

ate: The value of the parameter, 'value', is not legal.
Cannot convert parameter to a date.

(2) Could not convert data of type 'String' to type Date'. The types are
mismatched or the values are incompatible.

(3) Invalid character: 07/01/20"0"8

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Reply With Quote

#4

Old

Tony McGuire

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 03:59 PM

Joseph Misko wrote:

Quote:

In the script, I build a string based on criteria that is later
converted to a date. In this case the string is "07/01/2008" and I am
getting the following errors on the stack in Paradox X3.

(1) Date:Proc

ate: The value of the parameter, 'value', is not legal.
Cannot convert parameter to a date.

(2) Could not convert data of type 'String' to type Date'. The types are
mismatched or the values are incompatible.

(3) Invalid character: 07/01/20"0"8

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Reply With Quote

#5

Old

Tony McGuire

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 03:59 PM

Joseph Misko wrote:

Quote:

In the script, I build a string based on criteria that is later
converted to a date. In this case the string is "07/01/2008" and I am
getting the following errors on the stack in Paradox X3.

(1) Date:Proc

ate: The value of the parameter, 'value', is not legal.
Cannot convert parameter to a date.

(2) Could not convert data of type 'String' to type Date'. The types are
mismatched or the values are incompatible.

(3) Invalid character: 07/01/20"0"8

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Reply With Quote

#6

Old

Tony McGuire

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 03:59 PM

Joseph Misko wrote:

Quote:

In the script, I build a string based on criteria that is later
converted to a date. In this case the string is "07/01/2008" and I am
getting the following errors on the stack in Paradox X3.

(1) Date:Proc

ate: The value of the parameter, 'value', is not legal.
Cannot convert parameter to a date.

(2) Could not convert data of type 'String' to type Date'. The types are
mismatched or the values are incompatible.

(3) Invalid character: 07/01/20"0"8

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Reply With Quote

#7

Old

Tony McGuire

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 03:59 PM

Joseph Misko wrote:

Quote:

In the script, I build a string based on criteria that is later
converted to a date. In this case the string is "07/01/2008" and I am
getting the following errors on the stack in Paradox X3.

(1) Date:Proc

ate: The value of the parameter, 'value', is not legal.
Cannot convert parameter to a date.

(2) Could not convert data of type 'String' to type Date'. The types are
mismatched or the values are incompatible.

(3) Invalid character: 07/01/20"0"8

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Reply With Quote

#8

Old

Tony McGuire

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 03:59 PM

Joseph Misko wrote:

Quote:

In the script, I build a string based on criteria that is later
converted to a date. In this case the string is "07/01/2008" and I am
getting the following errors on the stack in Paradox X3.

(1) Date:Proc

ate: The value of the parameter, 'value', is not legal.
Cannot convert parameter to a date.

(2) Could not convert data of type 'String' to type Date'. The types are
mismatched or the values are incompatible.

(3) Invalid character: 07/01/20"0"8

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Reply With Quote

#9

Old

Joseph Misko

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 04:18 PM

"Tony McGuire" <png.paradoxcommunity@com> wrote

Quote:

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Fair questions. I am a minimalist, so the code is trivial. Either of the
following lines produce that identical error.

view(date("07/01/2008"))

msgInfo("", date("07/01/2008"))

I could reproduce the entire script here, but that is not the issue. String
to date conversion within Paradox only is not working on this one computer.
It is working fine on all other computers that we access.

Reply With Quote

#10

Old

Joseph Misko

Posts: n/a

Re: String to Date Conversion Error - 12-18-2008 , 04:18 PM

"Tony McGuire" <png.paradoxcommunity@com> wrote

Quote:

Show the code!

What code is resulting in the error(s)?
What is the code converting the value to a date, or trying to?

What happens if you do

msginfo("",date("07/01/2008"))

on that specific, same system?

--
---------------
Tony McGuire

Fair questions. I am a minimalist, so the code is trivial. Either of the
following lines produce that identical error.

view(date("07/01/2008"))

msgInfo("", date("07/01/2008"))

I could reproduce the entire script here, but that is not the issue. String
to date conversion within Paradox only is not working on this one computer.
It is working fine on all other computers that we access.

Reply With Quote

Reply

Page 1 of 6

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.