×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 3/16/2016 2:00 PM, Hoteltravelfundotcom wrote:
I have a input field which has date data.
S 128 135 0CTFDAT
No it doesn't. It has decimal data. Date data is stored in a Date
datatype:
Data Field Buffer Buffer Field
Field Type Length Length Position Usage
DATE1 DATE 10 10 11 Both
Field text . . . . . . . . . . . . . . . : Date data type
Date Format . . . . . . . . . . . . . . . : *ISO
Allows the null value
Coded Character Set Identifier . . . . . : 37
This is not nit-picking. It took me quite some time to reach this
point, but fields called 'date something' are not dates unless they are
Data Type = DATE.
This is important because it means a conversion is required, either from
DATE to decimal (once, to get CURRENT DATE into a decimal variable you
can compare against) or decimal to DATE (once for each record in the file).
its value is in YYYYMMDD.
I would like to compare against current date but I am not seeing
examples in this YYYYMMDD format.
If the date is not = to current date we would call an error condition.
My advice is to use an input parameter that you supply in the same
format. Then comparison is easy, and requires no conversions.
Furthermore, you can easily re-run the program for a different date.
Which might seem impossible until someone pushes off the daily work for
2 days because they insist that end of year takes place first.
midrange.com
