3 Replies Latest reply on Jan 25, 2017 1:47 PM by Alex Braun

    Date parsing from string in format of yyyym ?

    Neil Chakraborty

      I want to create a date variable from a string field which shows up year in the first 4 letters and last letter as the month. For example, the field shows value as 20169 as string which means year 2016 and month of September.

      What would be the date/dateparse function to be able to get to the date variable. Then I would use this date variable to create a time difference - datediff - between two date values.

       

      Thanks,