Re: jilian to Gregorian date conversion error

2018-04-29 Thread sum abiut
Hi Dennnis, Thank you for your email. My issue is i what to be able to display the rage of date base on the start and end date that was selected but i don't know how to do that. when i did a for look from my template for example. {%for a in result_proxy%} {{a.date_applied}} {%endfor%} i was ab

Re: jilian to Gregorian date conversion error

2018-04-25 Thread sum abiut
ok so i have fixed that using the for loop result_proxy=connection.execute(stmt).fetchall() for a in result_proxy: test=datetime.date.fromordinal(int(a.date_applied)) Now if i want to pass a range of date to date_applied above. How to i do that? I know in sql i did d

Re: jilian to Gregorian date conversion error

2018-04-24 Thread sum abiut
Thanks date example is 736788 in julian On Wed, Apr 25, 2018 at 12:34 PM, Dennis Lee Bieber wrote: > On Wed, 25 Apr 2018 00:55:39 +0100, MRAB > declaimed the following: > > > >Also, the integer is interpreted as a "proleptic Gregorian ordinal", not > >a Julian date. > > You didn't p

Re: jilian to Gregorian date conversion error

2018-04-24 Thread MRAB
On 2018-04-24 23:37, sum abiut wrote: Hi, i get the error message: an integer is required when i am try to convert from julian date to Gregorian date in my view.py, after i have query the db i want to convert the applied date from julian date to Gregorian date but i got the above error, con

jilian to Gregorian date conversion error

2018-04-24 Thread sum abiut
Hi, i get the error message: an integer is required when i am try to convert from julian date to Gregorian date in my view.py, after i have query the db i want to convert the applied date from julian date to Gregorian date but i got the above error, convert_date=(datetime.date.fromordinal(rat