3 Replies Latest reply: Mar 11, 2015 6:50 AM by Gabriel Oluwaseye RSS

    How load date from line?

    Виталий Чуприна

      I've received files with date inside. Now I want update  parser to automatically determine the date.

      I have two question:

       

      - How load date from line? I suppose, first I should determine row with date and them drop 'Data as of:'  

      - On picture below date is '3/1/2015', but this was Sunday and I need to load this data as 'Last Saturday'. Is there any function, that can automatically change date to last Saturday( for example 3/1/2015 - > 2/28/2015)

       

      Thanks,

      Vitaliy