You can use a function NOW() to get the current date&time. Then do whatever math to get the dates you want.