5 Replies Latest reply: Sep 8, 2014 6:08 AM by Manish Kachhia RSS

    Converting Date format

    Ridhaa Hendricks

      Hi There


      I need to convert the date format on the following date field.



      Trim(Replace([lst pym dt],'.','')) as [lst pym dt]


      The result of this is 01042014


      I need my result to be 20140401

      further on in my script I need to be able to multiply the Year, by 100

      if(Year(Trim(Replace([lst pym dt],'.','')))* 100 +Month(Trim(Replace([lst pym dt],'.',''))= '201401',[Payment],0)


      Thank you.