Hi I'm trying to do a Dcount on one of my tables but am having issues with date conversion from US to European. I'm running off dd/mm/yyyy everywhere else and this is the first time ive had a problem.
The Dcount works fine if the DD is greater then 12 but if the DD is equal to or less then 12 it returns a zero count.
I'm guessing that when the DD is greater then 12 it forces the US format of MM/DD/YYYY to become DD/MM/YYYY because obviously there is only 12 months.
i'm at a loss of why it is happening or how i fix it? Is it due to the way my system date is formatted or the format of the table date?
The Dcount works fine if the DD is greater then 12 but if the DD is equal to or less then 12 it returns a zero count.
I'm guessing that when the DD is greater then 12 it forces the US format of MM/DD/YYYY to become DD/MM/YYYY because obviously there is only 12 months.
i'm at a loss of why it is happening or how i fix it? Is it due to the way my system date is formatted or the format of the table date?
Code:
DCount("[LogDate]", "TblDBTracking", "[Subject_Task] like 'SSO*' and [LogDate]= #" & Date & "#")
