Project Planner Dcount - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Project Planner Dcount

Ian Finnylas

4 years ago

=Nz(DCount("TaskID","TaskT","ProjectID=" & [ProjectID] & " AND StartDate<=#" & [TargetDate]+2 & "# AND EndDate>=#" & [TargetDate]+2 & "#"),0)

This Dcount formula is not handling british dates correctly unless the day of the month is >12th. Does anybody know how to fix this please?

	Kevin Robertson @Reply 4 years ago
Format the date to the US standard format (MM/DD/YYYY).

	Alex Hedley @Reply 4 years ago
Oh the hours I've spent fixing date format bugs, such a pain

	Kevin Robertson @Reply 4 years ago
Agreed. One of the biggest headaches for non US developers.

	Helen Renaud @Reply 4 years ago
I have found problems if someone has chosen a different date format in Windows on their computer, than the Access database has formatted. For example: The computer might show in the taskbar "12-31-2022" but the Access format is "31-12-2022" Once I have changed the Windows date to the same format, it has resolved problems in Access. I don't know if this will help you or not.

	Richard Rost @Reply 4 years ago
And now you see why I changed everything to ISO dates.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View