Get time between a specific day from the previous month to our current date

[shod90]

Dear Gents ,
I have a report that i have to show records from a specific day of the previous month till our current date , So if the specific day is 25 , I need to show the records from 25th of July till 17th of Aug .

I tried many solutions but no hope , I only know how to do manually Between #7/25/2016# And Date() but i need it to be dynamically updated

[Gina Maylone]

Create a form with an unbound field "StartDate" where you will enter the specific date you need to report on. Reference the form/field in your query criteria.

SELECT REsidentVitals.REsidentID, REsidentVitals.DateTaken
FROM REsidentVitals
WHERE (((REsidentVitals.DateTaken)=[Forms]![Form1]![startdate]));

Hope this helps.

[shod90]

Thanks for your response , But i don't need that actually.
I need when the user log in to the main page it automatically calculates the total hours of what he worked from 25th of the previous month till today.

[CJ_London]

so you need to calculated a 25th of the previous month value from today? What if today is 26th of August? do you want 25th July or 25th August?

[shod90]

if today is 26th of August then the calculation should start from 25th August .

[CJ_London]

something like

SELECT sum(workhours)
FROM MyTable
WHERE workdate between dateadd("d",25-day(date()),dateadd("m",day(date())<=25,date())) and Date()

[shod90]

MANY THANKS it works !!! , See? it's very complicated