Something like that : next_week_sunday_date = \ (request.now.date() + datetime.timedelta(days=7)) + datetime.timedelta(days=6 - request.now.weekday())
rows_with_records_of_software_license_that_will_end_the_next_sunday = db(db.table_name.field_date_name == next_week_sunday_date ).select(db.table_name.ALL) Then : for r in rows_with_records_of_software_license_that_will_end_the_next_sunday: # get data you require from you table row and send you email Richard On Wed, Apr 11, 2018 at 4:01 AM, Prabhakar Shanmugam <prabs...@gmail.com> wrote: > Dear All, > > I have just started learning web2py and I have hands on in python. > > Please just give some pointers. Iam sure this might be a trivial question, > but I thought during the learning process I will ask this trivial question. > > I was seeing if i can write a license expiry daet management app, so that, > we get a notification well before the license expires. > > I was going through the documentation, and I got some examples for sending > emails, however, am not finding a way to identify a field value say a > expiry date field and then calculating it and seeing if it is 40 or less > days from today and notify. > > What are the options available to me to achieve this. > > Regards, > Prabhakar > > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.