sponsored links

Collapse

Announcement

Collapse
No announcement yet.

change 6 character date to 8 positions and to a date data type

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • change 6 character date to 8 positions and to a date data type

    How do i change a a 6 byte character field to an 8 position date field

  • #2
    Check the docs for the %DATE() built-in function.

    Comment


    • #3
      Code:
      MyDate = %date(@MMDDYY:*MDY0);

      Comment


      • #4
        what is the @ in front of the MMDDYY for?

        Comment


        • #5
          It is a special character in a field name, which should be avoided because special characters are NOT international (for example the @ sign is not allowed for variable name in a German environment, we can use the sign instead).

          Birgitta

          Comment

          sponsored links

          Collapse

          Working...
          X