VB Oracle Crystal Reports date problem

[renjukarsf]

Hi all

rr.SQLQuery = "select * from EXPORT where to_date(PLACEME NTDATE, 'DD/MM/YYYY') < TO_DATE('" & Format("17/08/2007", "YYYY/MM/DD") & "', 'YYYY/MM/DD') "

while executing the above querry im getting runtime error 2053 vb oracle8 and crystal report. Please help me to solve this urgent.


Renjith

[debasisdas]

Hi

Your previous post gives me wrong report. Im not getting the report according to my comparison

EG: im selecting date lessthan 11/07/20007 it shows all records

Thanks
Renjith

Do not blame others for your own mistake.

You need to change the query according to your requirment.

[renjukarsf]

Do not blame others for your own mistake.

You need to change the query according to your requirment.

Sorry you misunderstand , i just told what i got . The feedback i got was perfect i want to get as above , that only i mean , please advise

[debasisdas]

what is the version of CR that you are using ?

have you tried this

select * from EXPORT where PLACEMENTDATE < TO_DATE('2007/10/17', 'YYYY/MM/DD')

in the SqlQuery of the crystal report .

[renjukarsf]

what is the version of CR that you are using ?

have you tried this

select * from EXPORT where PLACEMENTDATE < TO_DATE('2007/10/17', 'YYYY/MM/DD')

in the SqlQuery of the crystal report .

I already tried but it is giving runtime error 20534

crystal report 8

[QVeen72]

Hi

Your previous post gives me wrong report. Im not getting the report according to my comparison

EG: im selecting date lessthan 11/07/20007 it shows all records

Thanks
Renjith

you passed date as 11/07/20007 , you will definately get wrong results...

What is the dateformat of your windows...?

Regards
Veena

[debasisdas]

I already tried but it is giving runtime error 20534

crystal report 8

Are you able to execute the select statment from SQL* PLUS ?

[renjukarsf]

Are you able to execute the select statment from SQL* PLUS ?

My windows date format is DD/MM/YYYY . Im passing date through a variable. My sql querry is executing. While generating report through using crystal the date comparison is making trouble, really struck up

[QVeen72]

Hi,

Pass this :

rr.RecordSelect ionFormula = "{EXPORT.Placem entDate} < Date( " _
& Format(frmdt, "YYYY, MM, DD") & ") "

CR follows a Particular Date Format, if you try to format it with "/", it may not accept.. and remove formatting for Fieldname also..

Regards
Veena

[renjukarsf]

Hi,

Pass this :

rr.RecordSelect ionFormula = "{EXPORT.Placem entDate} < Date( " _
& Format(frmdt, "YYYY, MM, DD") & ") "

CR follows a Particular Date Format, if you try to format it with "/", it may not accept.. and remove formatting for Fieldname also..

Regards
Veena

Hi
This gives me report with all the data in the database, comparison is not working, I think. For your reference I'm pasting the code. Please advise

        frmdt = Format(dtFrom.Value, "dd/mm/yyyy")
        todt = Format(dtTo.Value, "dd/mm/yyyy")
        rr.Reset
        rr.WindowState = crptMaximized
        rr.DiscardSavedData = True
        rr.Formulas(0) = "PlacementDtFrom = '" & frmdt & "' "
        rr.Formulas(1) = "PlacementDtTo = '" & todt & "' "
        rr.Connect = "userid=xxxx;pwd=xxxx;server=xxxx"
        rr.ReportFileName = App.Path + "\Report\AllPlacement.rpt"
        rr.SelectionFormula = "{EXPORT.PlacementDate} <= Date( " _
        & Format(frmdt, "YYYY,MM,DD") & ") and {EXPORT.PlacementDate} >= Date( " _
        & Format(todt, "YYYY,MM,DD") & ")"
        rr.SQLQuery = "select * from EXPORT"
        rr.Action = 1

[QVeen72]

Hi,

If it is for the period, there is a different syntax. You should have mentioned this before.
Check this :

rr.SelectionFormula = "{EXPORT.PlacementDate} In Date( " _
& Format(frmdt, "YYYY,MM,DD") & ") To Date( " _
& Format(todt, "YYYY,MM,DD") & ")"
 

Try to check commenting the rr.SQLQuery part and check.

Regards
Veena