10 Replies Latest reply: Aug 2, 2016 9:07 PM by jade wind RSS

    Function to convert financial year to date

    jade wind

      Hi everyone,

       

      I am new to QS and am trying to prepare my data so that I can create visualizations.

       

      In Excel I would use formula to convert a financial year to a date so that I can calculate between dates. For example the source data would show "FY 2015/2016" and I want to add a column in the data to convert it into "30/06/2016" as a date (then I can calculate age using DOB). Is there any function in QS that I can use to do it? Or if it's more convenient to do a "master dimension" I'll also be interested to know how.

       

      Thanks very much in advance for any help!