Jim
Javier Valencia wrote:
Jim: You may want to TRACE your code to make sure that the date variable does not get changed somewhere between where you capture it and the report. Also, you may have corruption on your report, try deleting the field and putting it back. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Limburg Sent: Friday, March 12, 2004 2:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Date is Integer
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
[EMAIL PROTECTED] wrote:
It's probably a jdate. Look at the report to see if there is something like:
vVar = (jdate(.#date))
Ben Petersen
On 12 Mar 2004 at 15:21, Jim Limburg wrote:
G-Day all
In a DOS 6.5 database I run into a report that is printing a variable that is a date field as a number like 2192621. for yesterday. The data in the column in the database is fine, or looks like it from the Browse window. The variable is getting to the report OK.
The variable is defined in the report as SET VAR vshipdate = .vship
It's code to run the report is:
SET VAR whval0 TEXT DIALOG 'Enter the Ship Date (MM/DD/YYYY):' whval0 whtemp 1 SET LINES=60 SET VAR vship DATE=.whval0 OUTPUT PRINTER PRINT shiplog WHERE shipdate = .whval0 + ORDER BY refnum ASC IF errvar <> 0 THEN
I have checked the Date format and seqence and they look good
I know I have seen this before, but can place my mind on the fix.
Jim
