Member Avatar for omi4u

I am working on my company's ledger and my accounts department need a search ledger by COA id with from date to date.

I am able to find the record from date to date but when I write the code for COA ID, then it ignore the date formula.

Below is my complete code that I tried

 {ledgerdetails.date} in {?datef}to{?dateto}

       and 
       {ledgerdetails.Accountnamedr} = {?tran} or 
      {ledgerdetails.accountnamecr}={?tran}

I also tried 

{ledgerdetails.date} >= {?datef}

         and

        {ledgerdetails.date} <= {?dateto}

For the backend, I'm using vb.net and MS SQL.

  • 1 Contributor
  • 1 Reply
  • 1K Views
  • 45 Minutes Discussion Span
  • Latest Post Latest Post by omi4u
Member Avatar for omi4u

problem solved

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.