Sub convert_seconds2Ticks(seconds As Long) As Long
seconds = seconds * DateTime.TicksPerSecond 'convert seconds to ticks!
I'm trying to convert a 24 hour time to 12 hour with AM/PM. I've tried to use the documentation for date/time formats.
Here's my code:
I know this been discussed here quite a few times, but I still am unable to format an SQL date field as I desire, it keeps showing me...
[entrCreate] INT NOT NULL DEFAULT (strftime('%s','now') *1000)
Make sure that the expression (strftime('%s','now') *1000) is enclosed...