Re: Witango-Talk: Dates Again Second Try

[Dan Stein]

Title: Re: Witango-Talk:  Dates Again Second Try

OK seems by trial and error I answered my own question

Without the service back SQL 2000 decides that 02 is 1902 for smalldate.

I decided to trap for the date being for digits this way

In the If Missing Action


<@ISNUM VALUE=”<@RIGHT STR=’<@ARG from_date>’ NUMCHARS=’4’>”> and setting the value=0

In the Results

<@IF EXPR=”<@ISNUM VALUE=’<@RIGHT STR=”<@ARG From_Date>” NUMCHARS=”4”>’>=0”>
You need to enter 4 digit years
</@IF>

on 6/2/02 9:23 AM, Dan Stein at [EMAIL PROTECTED] wrote:

> OK let me try asking it this way.
>
> Under what circumstances would a insert or update of a records write out as
> 1902 instead of 2002.
>
> DB Windows SQL 2000 SP ( not know for sure)
> WiTango App server SP1
> Windows 2000 Server

--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com