D dan_s New member Local time Today, 00:37 Joined Apr 22, 2008 Messages 9 Apr 22, 2008 #1 Hi, I have a database showing car details, and need to show all records whose MOT is due within the next 30 days/one month (from today) It might be similar to my first question. Thanks in advance Dan
Hi, I have a database showing car details, and need to show all records whose MOT is due within the next 30 days/one month (from today) It might be similar to my first question. Thanks in advance Dan
N namliam The Mailman - AWF VIP Local time Today, 01:37 Joined Aug 11, 2003 Messages 11,695 Apr 22, 2008 #2 It is exactly the same ! Just use + instead of - and use 30 instead of 14 ???
D dan_s New member Local time Today, 00:37 Joined Apr 22, 2008 Messages 9 Apr 22, 2008 #3 It's similar, but it will depend on the month surely? Is there a way to do it by month rather than days? Thanks Dan
It's similar, but it will depend on the month surely? Is there a way to do it by month rather than days? Thanks Dan
O odin1701 Registered User. Local time Yesterday, 17:37 Joined Dec 6, 2006 Messages 526 Apr 22, 2008 #4 Look up the DateAdd function in the help.
N namliam The Mailman - AWF VIP Local time Today, 01:37 Joined Aug 11, 2003 Messages 11,695 Apr 23, 2008 #5 Next 30 days is like I said... Exactly one month allways is what Odin said... Use the DateAdd function.
Next 30 days is like I said... Exactly one month allways is what Odin said... Use the DateAdd function.
