[MS_AccessPros] How to check if a date is among (belong to) a time interval?

 

Dear All,

How to check if a date is among (belong to) a time interval?

For instance, how to check if 05-Jan-2016 is among "01-Jan-2016 to 20-Jan-2016". My desired output would be, if the finding is yes, returns a value "True", otherwise returns "False". 

Best Regards,

Kevin

---

Regards,

Kevin Zhao

__._,_.___

---

Posted by: "zhaoliqingoffice@163.com" <zhaoliqingoffice@163.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___