Hi guys, this is gonna sound very simple but got a slight problem with the critera of one of my database's.
Basically i am looking to have a criteria in a Query that returns all the database fields that are 7 days old or less. Before i was using ">Date()-7" but since it turned September it's no longer working at it wont show any of the September database entries only the August ones that are still within the 7 day gap, ie. 29th, 30th and 31st August but nothing from September.
Anyone got any ideas how to fix this?
Thanks