[web2py] Re: Adding the number of day to a date

2015-02-02 Thread Anthony Smith
Hi Sorry misunderstood the question. T2.completed_date is triggered when someone enters the date the task is completed on. cheers On Tuesday, 3 February 2015 06:35:00 UTC+11, Dave S wrote: > > > > On Sunday, February 1, 2015 at 12:13:54 AM UTC-8, Anthony Smith wrote: >> >> Hi Richard >> >> the

[web2py] Re: Adding the number of day to a date

2015-02-02 Thread Dave S
On Sunday, February 1, 2015 at 12:13:54 AM UTC-8, Anthony Smith wrote: > > Hi Richard > > the trigger is T2.completed_date+T1.with_holding = T2.withhold_until > > I am reasonably new to web2py, can get though most things, but this has me. > > I think Richard was asking what event causes T2 to b

[web2py] Re: Adding the number of day to a date

2015-02-01 Thread Anthony Smith
Hi Richard the trigger is T2.completed_date+T1.with_holding = T2.withhold_until I am reasonably new to web2py, can get though most things, but this has me. cheers Anthony S On Sunday, 1 February 2015 18:42:34 UTC+11, Richard D wrote: > > Anthony S > > What is the trigger for this update of T

[web2py] Re: Adding the number of day to a date

2015-01-31 Thread Richard D
Anthony S What is the trigger for this update of T2 withholding _until? This will influence the solution drastically. Richard D On Saturday, January 31, 2015 at 8:47:47 PM UTC+1, Anthony Smith wrote: > > Hi > > I never explained it very well, > Table 1 has products with a with-holding period i

[web2py] Re: Adding the number of day to a date

2015-01-31 Thread Anthony Smith
Hi I never explained it very well, Table 1 has products with a with-holding period in days eg. product1 10 days, product2 7 7days etc Table2 has when, where, completed_date the product was used, it also has a withholding_until date field I am trying to get the T2 withholding _until to be updat

[web2py] Re: Adding the number of day to a date

2015-01-31 Thread Massimo Di Pierro
I do not understand the context of your question. In python you can do: d = datetime.datetime(2015,1,29,11,30,00) d = d + datetime.timedelta(days = 7) If a date is in a database you can do the same, you select, add and store it again. Some databases allow you to do it at the SQL level bu