Re: Witango-Talk: sql question

[robert]

Title: Re: Witango-Talk: �sql question

in witango i can show the date how i want but is use the sametble in access xp and when i want to edit the fiels the same dat show up and calc dont work properle ----- Original Message ----- From: Dan Stein To: Multiple recipients of list witango-talk Sent: Friday, July 05, 2002 3:33 PM Subject: Re: Witango-Talk: sql question I don�t think you can prevent the date wh3en you use Datetime as a field. But when you do your calculation if you user <@@local$mydate FORMAT:Datetime=�%H::%M:%S�> (for 24 hours clock. on 7/5/02 9:07 AM, robert at [EMAIL PROTECTED] wrote: i have a problem whit en sql table i have severall field that i use as time field and i do caclulation whit the times so i want just the tiem 10:30:00 to be in the field when i insert this in a sql table the field contains 1-1-1900 10:30:00 haw can i prevent that the date is also enterd in the field -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com