And if you need that to happen automatically on a regular schedule, you can use the web2py scheduler: http://web2py.com/books/default/chapter/29/04/the-core#web2py-Scheduler.
Anthony On Wednesday, April 11, 2018 at 10:52:03 AM UTC-4, Richard wrote: > > 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 <[email protected]> > 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 [email protected]. >> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
