one from a datetime picker n the other is a text field.. Am using this query.. dim arrtime as datetime arrtime = (Ccur(txttime.value)+( Ccur(txtdot.text)).. It shows type mismatch error...
Jump to Post
Your problem lies in your declaring a datetime, but you are using CCur (currency) to gte a value. to calculate 2 dates, do the following by using CDate and DateDiff functions -
========================================================================= ' Calculate user logged time in and out. ' ========================================================================= ' ssno ===> User …
All 4 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.