DATE functions

fogled@mizzou

I was just doing some date-based comparisons, and realized that the Netlinx DATE function returns a date in 2-digit year format mm/dd/yy, but... all the DATE_TO_X and DAY_OF_WEEK functions call for a 4-digit year input (mm/dd/yyyy).

I use DAY_OF_WEEK on the return of DATE without a problem. I guess I'm about to find out if the rest of the DATE_TO stuff if going to work on 2-digit year dates too...

AMXJeff

fogled@mizzou wrote: »

I was just doing some date-based comparisons, and realized that the Netlinx DATE function returns a date in 2-digit year format mm/dd/yy, but... all the DATE_TO_X and DAY_OF_WEEK functions call for a 4-digit year input (mm/dd/yyyy).

I use DAY_OF_WEEK on the return of DATE without a problem. I guess I'm about to find out if the rest of the DATE_TO stuff if going to work on 2-digit year dates too...

Use LDATE instead of DATE..

fogled@mizzou

AMXJeff wrote: »

Use LDATE instead of DATE..

Dang, that was too easy. Well, it would have been even easier if the Netlinx Help Keywords file would have mentioned LDATE in the DATE entry... Dang.

AMXJeff

LOL...

I guess indicating that LDATE was a keyword would of helped..

SINTEGER DATE_TO_DAY (CHAR LDATE[ ])