Topic: leaving date range blank Posted: 26 Aug 2012 at 6:26am
Formula Fields:
1) @Username_Formula (has string db column as {Command.Username}) 2) @Date_Formula (has date db column as Date({Command.DT})) 3) @Time_Formula (has string db column as TimeValue ({Command.TM}))
Parameter Fields:
1) {?Username_Parameter} (string data type) 2) {?Date_Parameter} (date data type with range values) 3) {?Time_Parameter}(time data type with range values)
Record Selection:
if {?Username_Parameter} = "" then
{@Date_Forumula} = {?Date_Parameter} and {@Time_Forumula} = {?Time_Parameter}
else if totext(@Date_Formula)= "" then
{@Time_Forumula} = {?Time_Parameter} and {@Username_Formula}={?Username_Parameter}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum