DATE functions

fogled@mizzou
fogled@mizzou h4x354x0r
in NetLinx Studio
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...
· Share on FacebookShare on Twitter

Comments

  • AMXJeff
    AMXJeff Senior Member
    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..
    · Share on FacebookShare on Twitter
  • fogled@mizzou
    fogled@mizzou h4x354x0r
    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.
    · Share on FacebookShare on Twitter
  • AMXJeff
    AMXJeff Senior Member
    LOL...

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

    SINTEGER DATE_TO_DAY (CHAR LDATE[ ])
    · Share on FacebookShare on Twitter

Categories