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.