Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sql date for msaccess
txs, ended up doing the following: Mid(left(Job.LastModified, 10), 5, 8) & '/' & Mid(left(Job.LastModified, 10), 3, 2) & '/' & Mid(left(Job.LastModified, 10), 1, 2) AS Dates -
sql date for msaccess
Is there a sql way to convert data "01/04/2008 1430" to appear as 2008/04/01? -
Convert data format
Txs, that's exactly what I ended up using. Appreciate pointing me in right direction.- neoxaml
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Convert data format
How can I use sql to convert the following text field data 5/14/2009 to display as 2009-05-14. I am using a text field. Thanks- neoxaml
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
trying to get 2 separate values in alert
On my error message both inspStartTime.StartTime & inspEndTime.EndTime end up being the same values returned. Although they each belogn to a different textbox. Any clues? for (int i = 0; i < VisualTreeHelper.GetChildrenCount(myVisual); i++) { //...- neoxaml
- Thread
- Replies: 1
- Forum: C# (C sharp): Microsoft
