Compare two dates in a loop

Next topic

Author	Message
Patrice DUCLAUD	Monday 02 May 2005 8:48:48 am How to compare two dates ? i'd like to do something with an object when his attribute (date) is greater than today, but i don't really know the right syntax something like that : {let Result=fetch('content','list', hash('parent_node_id,$node.node_id')} {section loop=$:Result show=le(currentdate(), $:item.object.data_map.date_attribute.data_int)} ... some code ... {/section} {/let} Thank for any solution

Author

Message

Monday 02 May 2005 8:48:48 am

How to compare two dates ? i'd like to do something with an object when his attribute (date) is greater than today, but i don't really know the right syntax

something like that :


{let Result=fetch('content','list',
            hash('parent_node_id,$node.node_id')}  
{section loop=$:Result 
         show=le(currentdate(),
   $:item.object.data_map.date_attribute.data_int)}
       ... some code ...
{/section}     
{/let}

Thank for any solution

eZ debug

Timing:	Jan 20 2025 05:12:34
Script start
Timing:	Jan 20 2025 05:12:34
Module start 'layout'
Timing:	Jan 20 2025 05:12:34
Module start 'content'
Timing:	Jan 20 2025 05:12:35
Module end 'content'
Timing:	Jan 20 2025 05:12:35
Script end

Main resources:

Total runtime	1.1291 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0060	589.1563	152.6250
Module start 'layout'	0.0060	0.0031	741.7813	39.4453
Module start 'content'	0.0091	1.1185	781.2266	399.6094
Module end 'content'	1.1275	0.0015	1,180.8359	8.1641
Script end	1.1291		1,189.0000

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	0.3233	16	0.0002
Check MTime	0.0015	0.1364	16	0.0001
Mysql Total
Database connection	0.0010	0.0925	1	0.0010
Mysqli_queries	1.0918	96.6971	46	0.0237
Looping result	0.0004	0.0347	44	0.0000
Template Total	1.0934	96.8	2	0.5467
Template load	0.0023	0.1994	2	0.0011
Template processing	1.0912	96.6411	2	0.5456
Template load and register function	0.0002	0.0181	1	0.0002
states
state_id_array	0.0017	0.1514	1	0.0017
state_identifier_array	0.0017	0.1511	2	0.0009
Override
Cache load	0.0018	0.1562	7	0.0003
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0762	1	0.0009
Fetch class attribute name	0.0008	0.0691	1	0.0008
XML
Image XML parsing	0.0001	0.0092	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0004	1	0.0000
General
dbfile	0.0006	0.0563	10	0.0001
String conversion	0.0000	0.0007	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs