🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Data Prep Week Function

Janet_21505

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

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Janet_21505

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