Data Prep Week Function

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
------------------------------
"