2 Replies Latest reply: May 15, 2014 9:58 AM by dmeyer _ RSS

    Date Conversion

    dmeyer _

      I have a report with a date displayed as 20051001 (yyyymmdd) I need to convert it to 10/01/2005.

       

      I tried the ctod function but it does not work. I get a "null" value, I have also tried setting field value to date/time and format to general I still get a "null" value

       

      Does anyone have a suggestion I can use.

       

      Thanks

        • Date Conversion
          RalphB _

          I have some reports with dates the same way.  The way I convert that is to go to the Options tab on the menu bar and select Input Options.  On there change the date format to "Y/M/D" selection. This will convert the date to the more traditional  "M/D/Y" format without changing the format of other dates you may have or need to work with.

          You can access this from either the report menu or the table menu.

           

          Ralph

          • Date Conversion
            dmeyer _

            That was easy!!!

             

            Thanks