Dcount -Date Criteria - Won´t find it -


Joined
Jan 25, 2021
Messages
1
Reaction score
0
Hi,
I need help, sorry my english.

I´ve this a date (01/01/2021) and it´s a holiday(TbHolidays) and i want to count if is or not to continue the function.
i ve this.
DateGO is 01/01/2021 and should find in Datehol Field in table TbHolidays the same date(is in shortdate too). but gives 0 and not 1.

Check = Nz(DCount("*", "tbHolidays", "[DateHol] = #" & DateGo & "#"), 0)
 

Attachments

  • NextWorkday test.zip
    124.8 KB · Views: 13
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top