how can I check if a datetime is between two datesTime

Ibtissam MS

Solved

Question

how can I check if a datetime is between two datesTime

10 Oct 2022

Rahul

MVP

Solution

Hi ,

You can use greater than and less than operator between dates.

Like below example -

CurrDate() > TextToDate("2022-10-01") and CurrDate() < TextToDate("2022-10-30")

You can use your dates in place of TextToDate("2022-10-01")

Hope this will help you.

10 Oct 2022

1 reply

10 Oct 2022

Show thread

Hide thread

Ibtissam MS

Thanks a lot It works now

10 Oct 2022

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.