14 Replies Latest reply: Jun 26, 2015 3:20 PM by Vitalii Chupryna RSS

    How load data from file name?

    Vitalii Chupryna

      Hi guys,


      I received files without date inside, so I need to load it from filename, but problem that date in following format:


      GenF JUNE WK 3.xlsx


      In this case how I should determine week ending date for I example I know that JUNE WK 3 = 2015-06-20.

      I think I should create calendar and then check the week number and month.

      Please advise the best way.