Error in Dcount criteria date format

[safeerbinsalih]

Error in Dcount criteria

I need to count number of records in a table (tblData_save) with with date field given in criteria. Date field is taken from a form (frmTransaction_input). The code is as follows

temp1 = DCount("*", "tblData_save", "[Enter_date] = #" & Format(Forms!frmTransaction_input.[Enter_date], "dd-mm-yyyy") & "#")

My date format is short date in Indian format dd-mm-yyyy.

Here the count is always returning 0 value. Criteria is not working.

Any help is appreciated

 

[JHB]

..
temp1 = DCount("*", "tblData_save", "[Enter_date] = #" & Format(Forms!frmTransaction_input.[Enter_date], "dd-mm-yyyy") & "#")

Try the below:

temp1 = DCount("*", "tblData_save", "[Enter_date] = #" &  Format(Forms!frmTransaction_input[B][COLOR=Red]![/COLOR][/B][Enter_date], "[B][COLOR=Red]mm/dd/yyyy[/COLOR][/B]") & "#")

 

[safeerbinsalih]

Thanks JHB, But it is not working. Still the count is returning 0 value

 

[JHB]

Try to replace it with a hard coded value, (change the date):

temp1 = DCount("*", "tblData_save", "[Enter_date] = #03/03/2016#)"

Else post your database with some sample data, (zip it) + where you've the problem.

 

[arnelgp]

try to use English (EN) format date:

temp1 = DCount("*", "tblData_save", "[Enter_date] = #" & Format(Forms!frmTransaction_input![Enter_date], "mm/dd/yyyy") & "#")

 

[JHB]

try to use English (EN) format date:

temp1 = DCount("*", "tblData_save", "[Enter_date] = #" & Format(Forms!frmTransaction_input![Enter_date], "mm/dd/yyyy") & "#")

That was suggested in post #2.