passing date to data report

Hello Experts !!
Please, i have problm.
i am trying to get a parameterised data report by passing date from form.
but it is not working. i am using dataevnironment.
In data environment what datatype of argument i have to select ?
secondly in dataenvironment when i right click command1 to see its properties, in parameters tab and then in parameter properties there are two lists for datatypes, one labeled Data type and second labeled Host Data Type. What is difference between both ?  
Please help.
Who is Participating?
Éric MoreauSenior .Net ConsultantCommented:
Hi soodsandeep,

This is explained in

soodsandeepAuthor Commented:
hello emoreau !!
yes it was right
but still one problem persists.
if i write :
select * from emp where hiredate=?
then i works but if i use :
select * from emp where hiredate<?
then it does not work properly.
can you help. please.

Éric MoreauSenior .Net ConsultantCommented:
>>then it does not work properly.

why? any error message?
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Éric MoreauSenior .Net ConsultantCommented:
is your date format ok?
soodsandeepAuthor Commented:
emoreau !
i think there is not error in date format. had it been some error, how could i get the correct output in first query : select * from emp where hiredate=?

i think the problem is due to how oracle compares dates ?
please look into.
Éric MoreauSenior .Net ConsultantCommented:
what would be the syntax in Oracle?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.