Deciphering a DCount function

[deda]

I have a snipped of VBA that I'm a little confused over

Me.TxtToDo = DCount("action", "tbl_To Do", "who like '" & GetUserName() & "*'" & " and x=" & 0 & " and [date] <#" & Date & "#") & " overdue" & " | " & _DCount("action", "tbl_To Do", "who like '" & GetUserName() & "*'" & " and x=" & 0 & " and [date] =#" & Date & "#") & " due today" & " | " & DCount( _
"action", "tbl_To Do", "who like '" & GetUserName() & "*'" & " and x=" & 0 & " and [date] >#" & Date & "#") & " future tasks"

I'm only looking for the overdue function, so I'm pretty sure that part is

DCount("action", "tbl_To Do", "who like '" & GetUserName() & "*'" & " and x=" & 0 & " and [date] <#" & Date & "#") & " overdue

. I looked up the documentation for the DCount function, so I know that it's pulling data from the tbh_To Do, however I'm really confused on the third parameter. I'm not sure what the strings are doing, and the "#", so I was wondering if someone could help me figure out what this function is doing. Thanks



(The reason I'm looking at the overdue part is because it is displaying more overdue tasks than there actually is)

[June7]

The # character is a date/time delimiter. It defines the date/time input to differentiate from rest of constructed string of characters.

Parameter for text type field needs apostrophe (or doubled quote marks) as delimiter. Number type field does not require delimiter.

[CJ_London]

suspect your issue is date formatting. By having Date as a separate text value (you are passing it into a string), it needs to be formatted US style of mm/dd/yyyy or database standard of yyyy-mm-dd.

So my guess is you do not use the US style but dd/mm/yyyy. This means that if the date is 10th June you will have 10/06/2022 - which in US style will be interpreted as 6th October.

The code has not been written very well and can be simplified to

Me.TxtToDo = DCount("action", "tbl_To Do", "who like '" & GetUserName() & "*' and x=0 and [date] < Date()") & " overdue"

really not a good idea to have fields with the same name as functions

and not sure why you are using username* - surely if your username is Rob, you don't also want user Robert, user Robina as well? So would think

Me.TxtToDo = DCount("action", "tbl_To Do", "who = '" & GetUserName() & "' and x=0 and [date] < Date()") & " overdue"