Please Give me the shortest formula for this ......statements..
If {?Trial} = "Today" then
{Order.CreateDateTime}= ...........For Today
else if {?Trial} = "Yesterday" then
{Order.CreateDateTime}.............For Yesterday
else if {?Trial} = "This Week" then
{Order.CreateDateTime}>...........First Day of Week and
{Order.CreateDateTime}.............Last Day Of week
else if {?Trial} = "Last week" then
{Order.CreateDateTime}>...............last week first day and {Order.CreateDateTime}< ......last week end day
else if {?Trial} ="This Month" then
{Order.CreateDateTime}>.........First day This month and {Order.CreateDateTime}<DateAdd ...........Last day this month
else if {?Trial} ="Last Month" then
{Order.CreateDateTime}>.........First day Last month and {Order.CreateDateTime}<DateAdd ...........Last day Last month
Edited by Vertex - 29 Oct 2009 at 12:46pm