hallo habs gefunden
(Year(Current Date - 7 days) * 10000 +
Month(Current Date - 7 days) * 100
+ (Day(Current Date - 7 days))) as von,
(Year(Current Date) * 10000 + Month(Current Date) * 100
+ Day(Current Date)) as bis
so funktionierts
oder gehts besser?