lake_shore
-
Posts
5 -
Joined
-
Last visited
Everything posted by lake_shore
-
Date Range Calculation
lake_shore replied to lake_shore's topic in Calculation Engine (Define Fields)
Thank you. Worked perfectly. I appreciate your quick reply. -
I want to calculate quarters for a series of date ranges. The following does not work. All records are reported as None for the field. The orginal field "Date" is a date field. Any suggestions? Case( Date >= 09/2/2003 & Date <= 10/31/2003, "Q1", Date >= 11/01/2003 & Date <= 01/16/2004, "Q2", Date >= 01/20/2004 & Date <= 04/02/2004, "Q3", Date >= 04/05/2004 & Date <= 6/25/2004, "Q4", "None")
-
Thank you for the fast reply. Just what I needed.
-
Is there a simple calculation which can evaluate whether a number is odd or even?
-
Is there a simple calculation which can evaluate whether a number is odd or even?