Dear Richard and Anthony, Thank you for both of your responses. I got an idea, am glad to try it out.
Thank you once again, let me try out in this direction. Regards, Prabhakar On Wed, Apr 11, 2018 at 8:57 PM, Anthony <abasta...@gmail.com> wrote: > 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 <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. > -- 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.
