Vb

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jeev
    New Member
    • Feb 2007
    • 1

    Vb

    how to retrive the datas in date wise format?can u pls help me with the code.
  • vijaydiwakar
    Contributor
    • Feb 2007
    • 579

    #2
    Originally posted by jeev
    how to retrive the datas in date wise format?can u pls help me with the code.
    which is thy backend try this
    select * from <table name> order by <date column>

    Comment

    • cmrhema
      Contributor
      • Jan 2007
      • 375

      #3
      MyRs3.Open "select * from employee dateofbirth =' " & cdate(text1.tex t)& " ' ", MyCon, adOpenKeyset, adLockOptimisti c
      Here text1.text contains date

      Comment

      • vijaydiwakar
        Contributor
        • Feb 2007
        • 579

        #4
        Originally posted by cmrhema
        MyRs3.Open "select * from employee dateofbirth =' " & cdate(text1.tex t)& " ' ", MyCon, adOpenKeyset, adLockOptimisti c
        Here text1.text contains date
        this won't work dear

        Comment

        Working...