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

[Danba]

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

[jtaylor___]

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

[Viking]

MyDate = %date(@MMDDYY:*MDY0);

[Danba]

what is the @ in front of the MMDDYY for?

[B.Hauser]

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