Member Avatar for pc20912

I try to making Birth Day reminder project, from VB.Net and MS-Access
There are Two tables, "Visitors" and "Employees"

"DateofBirthDB" field in Two tables with same format. (some few different fields also in Two tables)
I want to select all upcoming birth days from today onwards upto Yesterday,

Please expalin me to use "Select" query to get From Today to Yesterday.
(Only Month and Day)

Ex.
Today is 07-12-2013 then I want to select
07-Dec --- to ---> 06-Dec (that mean Jan,Feb.... then Yesterday) - in Order

  • 2 Contributors
  • 1 Reply
  • 255 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by M.Waqas Aslam
Member Avatar for M.Waqas Aslam

try this

select * from tbl
where DateOfBirth >= addDate(day,-1,getdate()) and DateOfBirth <= getdate()

you can also use between clause in where condition.

Hope this will give you any idea.

Regards

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.