Hi, Happy new year and hope you're all well. I have a query searching between 2 dates, it was working ok last year but i think its not working due to formatting now we're in 2022(?). The query I have is :
where I'm looking to search for the min and max dates in a column (that aren't closed, that's taken care of in the query)
The only formatting examples I've seen are of the type
and not of the type using the field in a query. Im using UK format dd/mm/yyyy
Could someone let me know please if this looks like I'm using the query wrong
regards
Code:
Between DMin("[registered]","tblRma") And DMax("[registered]","tblRma")
where I'm looking to search for the min and max dates in a column (that aren't closed, that's taken care of in the query)
The only formatting examples I've seen are of the type
Code:
<#2/2/2012# or >#2/4/2012#
and not of the type using the field in a query. Im using UK format dd/mm/yyyy
Could someone let me know please if this looks like I'm using the query wrong
regards