Can Someone help me with this:
I have six numeric parameters and three numeric data fields:
parameters:
year1
year2
month1
month2
day1
day2
database:
year to num
month to num
day to num
I am trying to write a select formula to select records between the 2 user defined dates.
Starting date: month1/day1/year1
Ending Date: month2/day2/year2
i tried this, but it gave me no results:
{@year to num} in {?year1} to {?year2} and
if ({@year to num} = {?year1}) then {@month to num} >= {?month1} and
if ({@year to num} = {?year2}) then {@month to num} <= {?month2} and
if ({@year to num} = {?year1} and {@month to num} = {?month1}) then {@day to num} >= {?day1}and
if ({@year to num} = {?year2} and {@month to num} = {?month2}) then {@day to num} <= {?day2}and
Can somebody PLEASE HELP me???????????
I have six numeric parameters and three numeric data fields:
parameters:
year1
year2
month1
month2
day1
day2
database:
year to num
month to num
day to num
I am trying to write a select formula to select records between the 2 user defined dates.
Starting date: month1/day1/year1
Ending Date: month2/day2/year2
i tried this, but it gave me no results:
{@year to num} in {?year1} to {?year2} and
if ({@year to num} = {?year1}) then {@month to num} >= {?month1} and
if ({@year to num} = {?year2}) then {@month to num} <= {?month2} and
if ({@year to num} = {?year1} and {@month to num} = {?month1}) then {@day to num} >= {?day1}and
if ({@year to num} = {?year2} and {@month to num} = {?month2}) then {@day to num} <= {?day2}and
Can somebody PLEASE HELP me???????????