[TYPO3-english] show only records of the next month
Sven Jürgens
news at blue-side.com
Tue Oct 14 14:33:19 CEST 2008
Hello,
has anybody a hint for me.
I want use show only records of the next Month.
At the Moment i use this Typoscript
20 = CONTENT
20 {
table = my_Extension_table
select {
pidInList = 3005
orderBy = date ASC
selectFields = uid,category,date,time,title,text,image ...
#get records from now
andWhere.dataWrap = date+time>={date:U}
# get records from now till timestamp:1223935200
andWhere.dataWrap = date+time>={date:U} AND date+time<= 1223935200
}
It's possible to set the timestamp automatically to the end of the next
month ?
Or is there a completly other way to solve this ?
Thanks for your help.
Sven
More information about the TYPO3-english
mailing list