Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

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