Current i have a for loop
<table>
<tr>
<th>Date</th>
</tr>
{% for a in results %}
<td>{{a.date_applied}}</td>
{%endfor%)
</table>
currently the date is in julian date. i wan to convert the date to
gregorian date. Is there a way to do that in the template.
On Wed, Apr 25, 2018 at 1:50 PM, sum abiut <[email protected]> wrote:
> I have a function that query the db and extract and display data on a
> template
>
>
> def bydate_display(request):
> if "selectdate" in request.POST and "selectdate1" in request.POST and
> "selectaccount" in request.POST:
> selected_date = request.POST["selectdate"]
> selected_date1 = request.POST["selectdate1"]
> selected_acc = request.POST["selectaccount"]
> if selected_date==selected_date and selected_date1==selected_date1
> and selected_acc==selected_acc:
> convert=datetime.datetime.strptime(selected_date,
> "%Y-%m-%d").toordinal()
> convert1=datetime.datetime.strptime(selected_date1,
> "%Y-%m-%d").toordinal()
> engine=create_engine('mssql+pymssql://username:password@serve
> /db')
> connection=engine.connect()
> metadata=MetaData()
> fund=Table('gltrxdet',metadata,autoload=True,
> autoload_with=engine)
> rate=Table('gltrx_all',metadata,autoload=True,
> autoload_with=engine)
>
> stmt=select([fund.columns.account_code,fund.columns.
> description,fund.columns.nat_balance,fund.columns.rate_
> type_home,rate.columns.date_applied,rate.columns.date_
> entered,fund.columns.journal_ctrl_num,rate.columns.journal_ctrl_num])
> stmt=stmt.where(and_(rate.columns.journal_ctrl_num==
> fund.columns.journal_ctrl_num,fund.columns.account_code==
> selected_acc,rate.columns.date_applied.between(convert,convert1)))
> results=connection.execute(stmt).fetchall()
>
>
> return render(request,'bydatedisplay.html',locals())
>
>
--
______________________________________________________________
| Sum Abiut |
*Security Blog : Security Tips <http://mysecuritytips.wordpress.com/> |
Programming Blog: Programming <http://mrcoderguide.wordpress.com>*
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAPCf-y71cq3H8XvzAcUp4ndthjwtq4ZGQkmzMcf44rLvpeqmgQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
