|November 26, 2010, 00:00||
What is the correct date format?
Join Date: Nov 2010
Location: Phuentsholing, Bhutan
Posts: 1Rep Power: 0
I'm using VB6 with MS Access in back end. And the problem is when I add the records, the date format that I get from date picker is not entered into the table as intended. See example below for more clearity:
Dim strDate as String
strDate = "#" & DTPicker1.Day & "/" & DTPicker1.Month & "/" & DTPicker1.Year & "#". Also I even tried just DTPicker1.Value that too didn't work.
And in back end in table date field I'm using Short Date format like 16/6/2007.So When I entered 3rd Feb,2010(03/02/2010). It's just coming opposite that is 2nd Mar,2010(02/03/2010) in the table.
Therefore, Can any expert could help me & I would be grateful to you please...
|Thread||Thread Starter||Forum||Replies||Last Post|
|Moving mesh||Niklas Wikstrom (Wikstrom)||OpenFOAM Running, Solving & CFD||122||June 15, 2014 06:20|
|Patches for OpenFOAM 1.7 on MacOS X||gschaider||OpenFOAM Installation on Windows, Mac and other Unsupported Platforms||101||September 21, 2011 05:37|
|OpenFOAM 1.6 package - CentOS 5.3 x86_64||linnemann||OpenFOAM Installation||36||September 2, 2009 12:46|
|Gcc for SGI IRIX 65||Ali (Ali)||OpenFOAM Installation||58||April 24, 2008 05:02|
|Errors running allwmake in OpenFOAM141dev with WM_COMPILE_OPTION%3ddebug||unoder||OpenFOAM Installation||11||January 30, 2008 21:30|