Member Avatar for Hemanth.Satkuri

Hi,

When i communicate with user first time recent_date will be of that date , I want to query all the rows based on recent_date>= 2 and if day of recent_date is Thursday then recent_date >=4 and if it is friday then recent_date>=4
Basically I dont want to count Saturday & Sunday as part of reminder

Help with the Query..

select id from table where recent_date>=(IF DAYNAME(recent_date) IN('Thursday','Friday'),4,2);

Thanks :)

Edited by Hemanth.Satkuri
  • 1 Contributor
  • 1 Reply
  • 59 Views
  • 32 Minutes Discussion Span
  • Latest Post Latest Post by Hemanth.Satkuri
Member Avatar for Hemanth.Satkuri

Also is it possible to have Date & Time Picker in Swing...?

Edited by Hemanth.Satkuri
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.