View Single Post
Old 10-06-2021, 06:08 AM   #175
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,495
Karma: 8065348
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by ownedbycats View Post
Thank you.

Any idea why the template search in #170 runs inconsistently on custom datetime fields? It only returns #fanficupdated values that are from the last few days, and nothing at all from #lastmodified. I don't think it's the formatting of the columns - it's using raw_field.
My guess is that you are not in the UTC time zone so the value you see is not the value stored in the database. See 3 posts back. Try the template @capink posted that takes the time zone into account:
Code:
template:"program:
	format_date($$timestamp, 'hh:mm')#@#:t:00:00"
If that doesn't work then we will need example failing raw_date() text to find the problem. Something like the output of this template:
Code:
program:
	strcat($$timestamp, ' ::: ', format_date($$timestamp, 'hh:mm'))
chaley is offline   Reply With Quote