Dcount -Date Criteria - Won´t find it -

J

joaofigu

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: 95

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

Similar Threads

VBA - exporting serial letters to single documents 0
How to use/create code in MS Word to calculate age? 0
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
countifs Function not giving desired result with date criteria 2
compare date range with date in columns and input data from another cell 2
DCount Not Working Properly 7
How to disable Alt+s in Outlook 365 0
Date Format - simple question 1

Top