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...
Rizvi404
0
Newbie Poster
Recommended Answers
Jump to PostYour 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
AndreRet
526
Senior Poster
Rizvi404
0
Newbie Poster
Rizvi404
0
Newbie Poster
WaltP
2,905
Posting Sage w/ dash of thyme
Team Colleague
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.