Data Prep Week Function

Janet_21505
Janet_21505 Altair Community Member
edited May 2019 in Community Q&A
This is a simple function, but for some reason, I cannot get this to work.  I want to know know what week from the start date of 05/01/2018 is the Transaction Entry Date.

Week([Transaction Entry Date],05/01/2018)

Janet Grimsley

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------
Tagged:

Answers

  • Janet_21505
    Janet_21505 Altair Community Member
    edited May 2019
    Well. the light bulb finally turned on.  :)  Used FiscalWeek([Transaction Entry Date])  and changed the Fiscal Year setting in the workspace.  I am good.  


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 05-14-2019 11:06 AM
    From: Janet Grimsley
    Subject: Data Prep Week Function

    This is a simple function, but for some reason, I cannot get this to work.  I want to know know what week from the start date of 05/01/2018 is the Transaction Entry Date.

    Week([Transaction Entry Date],05/01/2018)

    Janet Grimsley

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "

Categories