[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