I have user enter 03/12/2004 -- full date.

I even tested 03/12/04 and it worked under trace.

September 28, 3997 BC ... I'm may have just become a grandpa, but I'm not that old..

Ha, ha

Jim

Bill Downall wrote:

Jim,

How is the data entry done at the DIALOG? Number pad dates as in 03032004?

Is there a chance that you are seeing an internal date serial number, elapsed days since december 31, 4000 BCE?

Actually, that looks pretty likely. I just subtracted your number from .#DATE and got September 28, 3997 BC.

R>set date format 'MM/DD/YYYYCC'
R>sho v #date
03/12/2004AD
R>set var vdate1 = (.#date - 2191621)
R>sho v vdate1
09/28/3997BC

Bill

At 03:38 PM 3/12/2004, you wrote:

No. It is just like it is defined below ... the report var is set to the
variable outside the report that is gotten after the dialog.

SET VAR vshipdate = .vship

Jim






Reply via email to