Thank you Anthony,
I was beginning think that it had to be bug. It just didn't make sense.
So, when I said not to mess with the date format on insert to the database -
it is okay IF what you have to do is convince Witango that the format is one
of which it can understand :-}
I hope Anthony helped solve your problem Vicky. Cheers....
----- Original Message -----
From: "Anthony M. Humphreys" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 1:55 PM
Subject: Re: Witango-Talk: Date Issue
RE: Witango-Talk: IE browser share now 93% in 2002 (Off topic news)Tango was
originally coded in North America. Historically, we've used mm/dd/yy as out
default date format. Other people have used other formats over time. Some of
use have become more enlightened over time and realized that YYYY/mm/dd was
easier to read, less ambigous and easier to file -- Its even the ISO short
date format. But we often go back to our roots.
That said, Tango, by default, thinks that any dates are entered mm/dd/yy or
mm/dd/YYYY by default and you'll have to convice Tango that it's otherwise
like so:
<@ASSIGN SCOPE=local NAME=DateToUse VALUE='<@FORMAT STR="<@ARG
DateFromTheForm>" INFORMAT="datetime:%d/%m/%y">' FORMAT="datetime:<@VAR
dateFormat>">'>
Then use the Var "DateToUse" rather than the Arg in your
insert/update/deletes
----- Original Message -----
From: Vicky Bagwalla
To: Multiple recipients of list witango-talk
Sent: Friday, June 14, 2002 16:30
Subject: RE: Witango-Talk: Date Issue
Here you go :
Note: Three dates
PurchaseDate - Entered on Form (dd/mm/yyyy)
Received Date - Entered on Form (dd/mm/yyyy)
EntryDate - <@CURRENTDATE>
Date entered as 10/06/2002 in the form (For Purchase and Received date)
INSERT INTO dbo.tblR
(REntryID,UserEntryNum,RCode,ProductModel,FirstName,LastName,Address1,Addres
s2,City,ProvID,PCode,ZipCode,PhoneArea,PhoneF3,PhoneL4,EmailAddress,SerialNu
mber,Store,MediaID,InflID1,InflID2,PurchaseDate,ReceiveDate,EntryDate,Entere
dBy,OKtoprint,ProblemID1,ProblemID2,ProblemID3,Bill,Coupon,UPC,Comments,HPQu
estion1,HPQuestion2,HPQuestion3,HPQuestion4,EnteredUsing,RAmount,EntryAlert,
AlertReason) VALUES
('HO150075','VB-75','HO','845C','Jh',NULL,NULL,NULL,NULL,0,'
',?,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,{ ts '2002-10-04
00:00:00' },{ ts '2002-10-04 00:00:00' },{ ts '2002-06-14
00:00:00' },'vickyb','N',0,0,0,NULL,NULL,0,NULL,'','','','',?,40.00,'','')
Date entered as 14/04/2002 in the form (For Purchase and Received date)
INSERT INTO dbo.tblR
(REntryID,UserEntryNum,RCode,ProductModel,FirstName,LastName,Address1,Addres
s2,City,ProvID,PCode,ZipCode,PhoneArea,PhoneF3,PhoneL4,EmailAddress,SerialNu
mber,Store,MediaID,InflID1,InflID2,PurchaseDate,ReceiveDate,EntryDate,Entere
dBy,OKtoprint,ProblemID1,ProblemID2,ProblemID3,Bill,Coupon,UPC,Comments,HPQu
estion1,HPQuestion2,HPQuestion3,HPQuestion4,EnteredUsing,RAmount,EntryAlert,
AlertReason) VALUES
('HO150076','VB-76','HO','845C','Jh',NULL,NULL,NULL,NULL,0,'
',?,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,{ ts '2002-04-14
00:00:00' },{ ts '2002-04-14 00:00:00' },{ ts '2002-06-14
00:00:00' },'vickyb','N',0,0,0,NULL,NULL,0,NULL,'','','','',?,40.00,'','')
Thanks
- Vicky
Vicky Bagwalla
AReA Communications.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Steve Smith
Sent: June 14, 2002 3:50 PM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: Date Issue
Can you turn on debug for the taf and run it twice, once with a day less
than 12 and once with a day greater than 12. Cut and paste the SQL
expression from each into a message and post it to the list for all of us to
see.
Thanks,
Steve Smith
Skadt Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: [EMAIL PROTECTED]
Web: http://www.skadt.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Vicky Bagwalla
Sent: June 14, 2002 3:25 PM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: Date Issue
Through Tango, I am passing the date as %d-%b-%Y (Evaluates to
14-Jun-2002) into a column "datetime" in the database. Now the SQL user for
this database (DSN on dev and deployment is set to BRITISH ENGLISH). All is
ok and the value inserted in the database is 14/06/2002.
PROBLEM : If the "day" part of the date is < 12 then the database flips
month and day around . Example : 10-Jun-2002 . SHOULD be stored as:
10/06/2002 but is stored as 06/10/2002.
Really really need help with this silly thing.
Note : I can then go into SQL directly and enter date as 10/06/2002 no
problem. Only through Tango !!!
You may contact me off the list too at : [EMAIL PROTECTED]
Thanks !
- Vicky
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
