1 2 Previous Next 21 Replies Latest reply on Jan 10, 2014 11:47 AM by Carly Capitula

    How do I convert the following using DATEPARSE?

    Peter Gilks

      I have a date field that is only year and month and is in the format

      2013/001

      2013/002

      2013/003

       

       

      etc.....

       

      I would like to use the DATEPARSE function to get it as a date field, but I'm not sure how as dealing with that extra 0 on the month is not standard.

       

      I know of other ways to do this, so please don't worry about providing other solutions, but would love to know if there is a solution that uses a single calculated field and DATEPARSE,

       

      thanks

       

      Peter

        1 2 Previous Next