The example I have is = Second (#10:13:58 AM#) and the argument must be a valid time.
But what if the numbers are strings? How could it be formatted to avoid a Type Mismatch error?
Minute and Second
Competent Performer
Windows 10 
Access 2019
The example I have is = Second (#10:13:58 AM#) and the argument must be a valid time.
But what if the numbers are strings? How could it be formatted to avoid a Type Mismatch error?
VIP
Windows 10 Access 2010 32bit
Possibly convert with CDate() function.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 10 Access 2019
I though of that too. Did it work for you ?
VIP
Windows 10 Access 2010 32bit
You did not try?
VBA immediate window:
?IsDate(CDate("10:13:58 AM"))
returns True
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 10 Access 2019
Thanks June I have it now.
VIP
Windows 10 Access 2010 32bit
Be aware conversion functions error if input is Null. If that is possibility, can handle Null with Nz()
CDate(Nz(field,0))
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Grouping by 15 minute periods
Last minute requests SOS
Combining data within minute
Posting Permissions
Reply With Quote