Member Avatar for KARNANI ASHOK

Hello i wish to display in our local intranet site birthday of employees as per the database for next three days. it has displaying for current date data only. please guide - how to edit the asp page for displaying the birthdays of employees for the next three days in the page where it is showing for the day only. thankx

  • 2 Contributors
  • 1 Reply
  • 45 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for dickersonka

I don't know what your code is, but you should change your sql code

select * from employees where 
DateDiff(dd, getdate(), dateofbirth) between 0 and 3

you might need to change the 3 to 2 depending if you are including or excluding it

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.