Istudent Rana

Istudent Rana

  • 1.3k
  • 311
  • 79.1k

How do i find employee who are hired 6 weeks ago from curren

Jul 26 2019 7:11 AM
How do i find employee who are hired 6 weeks ago from current running weeks?
My current code executes a query in access DB and filters the data based on WeekNumber Column given by below query..
IIf(Weekday([HiredDate])=7,[HiredDate],[HiredDate]-Weekday([HiredDate])) AS TrainingStart,
Date()+6-Weekday(Date()) AS EndOfWeek,
DateDiff("ww",[TrainingStart],[EndOfWeek]) AS WeekNumber 
We do not have access db anymore and i need to get the data from Oracle db.
How do I write to get same data in this situation?

Answers (1)