Trying to add where condition from a from:
:
:
:
'Add the condition for from date
If Len(Me.cboFromDate) > 0 Then
Set boCond = bodp.Queries.Item(1).Conditions.Add("Rep Trades", "Execution Date", "Greater than or equal to", cboFromDate & "00:00:00"
CondFormatCount = 1
End If
'Add the condition for to Date
If Len(Me.cboToDate) > 0 Then
Set boCond = bodp.Queries.Item(1).Conditions.Add("Rep Trades", "Execution Date", "Less than or equal to", cboToDate & "23:59:59"
CondFormatCount = CondFormatCount + 1
End If
:
:
:
I get the error :
ORA-00907: missing right parenthesis : - 907
is there more to it with dates... do i need a to_date function?
Any help appreciated.
I feel as if I'm asking load here ... new to B.O. and still finding my feet.
Bill Paton
Check out
:
:
:
'Add the condition for from date
If Len(Me.cboFromDate) > 0 Then
Set boCond = bodp.Queries.Item(1).Conditions.Add("Rep Trades", "Execution Date", "Greater than or equal to", cboFromDate & "00:00:00"
CondFormatCount = 1
End If
'Add the condition for to Date
If Len(Me.cboToDate) > 0 Then
Set boCond = bodp.Queries.Item(1).Conditions.Add("Rep Trades", "Execution Date", "Less than or equal to", cboToDate & "23:59:59"
CondFormatCount = CondFormatCount + 1
End If
:
:
:
I get the error :
ORA-00907: missing right parenthesis : - 907
is there more to it with dates... do i need a to_date function?
Any help appreciated.
I feel as if I'm asking load here ... new to B.O. and still finding my feet.
Bill Paton
Check out