Re: [web2py] Re: Upcoming birthdays

Thanks again everyone. Here is what I came up with for a solution. I really appreciate all the helpful input. # find the upcoming birthdays start_date = request.now.date() end_date = start_date + relativedelta(months=+1) this_month = db((db.employee.dob.month() == start_date.month) &

Re: [web2py] Re: Upcoming birthdays

Thanks, I'll work through this and post my code once I get to the office this morning. -Jim On Wed, Oct 4, 2017 at 4:25 AM, Dave S wrote: > > > On Tuesday, October 3, 2017 at 5:08:27 PM UTC-7, Dave S wrote: >> >> >> >> On Tuesday, October 3, 2017 at 4:48:52 PM UTC-7, Jim

Re: [web2py] Re: Upcoming birthdays

On Tuesday, October 3, 2017 at 5:08:27 PM UTC-7, Dave S wrote: > > > > On Tuesday, October 3, 2017 at 4:48:52 PM UTC-7, Jim S wrote: >> >> I don't think that will do it. The date stored in the database would be >> 10/15/1980, or 10/21/1993. >> >> Those should both show a birthday in the month

Re: [web2py] Re: Upcoming birthdays

Thanks everyone. Time for me to call it a night. I'll give it a run tomorrow morning. -Jim On Tue, Oct 3, 2017 at 9:46 PM, Limedrop wrote: > What about something like this... > > import datetime > now = datetime.datetime.now() > the_future = now +

Re: [web2py] Re: Upcoming birthdays

On Tuesday, October 3, 2017 at 4:48:52 PM UTC-7, Jim S wrote: > > I don't think that will do it. The date stored in the database would be > 10/15/1980, or 10/21/1993. > > Those should both show a birthday in the month of August. > Er, October? > But, I don't want just a matching month. I

Re: [web2py] Re: Upcoming birthdays

I don't think that will do it. The date stored in the database would be 10/15/1980, or 10/21/1993. Those should both show a birthday in the month of August. But, I don't want just a matching month. I want it for the next 30 days. So, on December 15th I should see all birthdays between December

[web2py] Re: Upcoming birthdays

On Tuesday, October 3, 2017 at 2:38:38 PM UTC-7, Jim S wrote: > > Stifan > > I use that method to build dates quite often. However, I don't know how > to translate that into a DAL query. > > -Jim > > I have an example, but it's at home. /dps > On Tuesday, October 3, 2017 at 4:18:30 PM

[web2py] Re: Upcoming birthdays

Stifan I use that method to build dates quite often. However, I don't know how to translate that into a DAL query. -Jim On Tuesday, October 3, 2017 at 4:18:30 PM UTC-5, 黄祥 wrote: > > perhaps you can use python datetime module. > e.g. > import datetime > print (datetime.date.today() +

[web2py] Re: Upcoming birthdays

perhaps you can use python datetime module. e.g. import datetime print (datetime.date.today() + datetime.timedelta(1*365/12)).isoformat() or from datetime import date from dateutil.relativedelta import relativedelta six_months = date.today() + relativedelta(months=+1) The advantage of the