Member Avatar for abu taher

in data environment i write

Select * from item where date and date between DTFr.value and DTTo.vlaue

In button I write

Load DataEnvironment1
    With DataEnvironment1
    If .rscmborder.State <> 0 Then .rscmborder.Close
     .cmborder Format(DTFr.Value, "dd/mm/yyyy"), Format(DTTo.Value, "dd/mm/yyyy")
     End With
     drorder.Show

but the report show all item from 1st date. it not show the range of date. (What I selected)

  • 3 Contributors
  • 3 Replies
  • 111 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for QVeen72

Hi,

In D.Env, u have to write:
Select * from item where date and date between ? and ?

Then select appropriate type in parameter list..

Regards
Veena

Member Avatar for abu taher

ya i did it.

Member Avatar for AndreRet

Abu, have a look at THIS link. it will give you the options you need.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.