79526650

Date: 2025-03-21 22:12:20
Score: 3
Natty:
Report link

None of the options above are good for Report Builder.

I need to convert a string (date) to date format.

Hire Date shows as 01011999 I need 01/01/1999

I attempted using
CHAR(DIGITS(HDT#01):1 2) || '/' || CHAR(DIGITS(HDT#01):3 2) || '/' || CHAR(DIGITS(HDT#01):5 4)
But report builder does not allow :

Reasons:
  • Blacklisted phrase (0.5): I need
  • Low length (0.5):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: sam