11 Replies Latest reply: Jun 30, 2017 4:53 AM by Alison Cooke RSS

    Creating Quarters Field

    Alison Cooke

      Hello Everyone,


      I am looking for some advice on how to create a quarters field.


      To give you some background, I have a script that looks like this, it's pretty simple:


      Screenshot (7).png

      So, I had a number of tables which each have tables for Employee ID, Gender and Current Job Title. Each table pertain to a different month so I used the FileBaseName function to generate a field based on the name of the excel document.


      Now, would it be possible to generate a field called quarters?


      If you could, please provide an explanation of how your expression works, as this is just a test and I'd like to be able to apply the solution myself to other data sets.


      Thank you in advance,