sportsguy
Finance wiz, Access hack
- Local time
- Today, 17:57
- Joined
- Dec 28, 2004
- Messages
- 363
SQLSERVER text extract for datetime has a text format with milliseconds.
'2015-07-13 15:20:25.0000'
MS Access link table format can't handle more than 19 characters, or the period and anything to the right of the period.
Exporting the SQLSERVER date time as LEFT(CREATED_DATETIME,19) as text
results in 'Jul 13 2015 3:16PM'
So the question is, how to create a table input mask to turn 'Jul 13 2015 3:16PM' text into MS Access datetime?
Anyone ever try this before?
Thanks, sportsguy
'2015-07-13 15:20:25.0000'
MS Access link table format can't handle more than 19 characters, or the period and anything to the right of the period.
Exporting the SQLSERVER date time as LEFT(CREATED_DATETIME,19) as text
results in 'Jul 13 2015 3:16PM'
So the question is, how to create a table input mask to turn 'Jul 13 2015 3:16PM' text into MS Access datetime?
Anyone ever try this before?
Thanks, sportsguy