Hi
I have the following code to count the number of occurances that a date (DateCheck) occurs with a corresponding Depot name (Depot). This code is not picking up the two variables.
Any advice why it is not working?
Thanks
Please Login or Register to view this content.
It must be something to do with dates (DateCheck) because when I checked with another stricg critera, it worked.
Most puzzling!
Thanks
Hi, newbi004,
as you only supplied the code but no workbook/userForum and we donīt know what value txtWeekCommencing.Value is itīs hard to tell. I changed the UF.Textbox to a date and it worked fine for me, maybe you could use DateValue or DateSerial to get a "standard" date from the textbox:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Brilliant Holgar! Using DateValue did the trick.
Thanks very much
One blind shot..
Change this line..
DateCheck = clng(txtWeekCommencing)
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Thanks for your response, Debraj Roy.
I tried clng before and it didn't work in my instance. The DateValue is the way forward.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks