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?