Mar 20, 2008 · I need to use VBA to convert a field in an imported table from a text data type to a date/time data type. Any suggestions greatly are appreciated.

Mar 1, 2013 · Add the current time as a decimal value to the end of the Julian date and store. When recovering, take the decimal value off the Julian before conversion and change the …

May 13, 2004 · Hi im hoping someone can help me here please. I have a datetime picker which returns a selected date like: 01/12/2004 I need to convert this to a julian number. In excel its …

Oct 5, 2005 · While trying to input some date variables in an Excel 2000 VBA subroutine, I ran into a curious problem: My default short date format (according to the Regional and Language …

Oct 3, 2006 · Hi, Hopefully a simple question. I wish to convert a variable holding the date (format dd/mm/yy) into an integer (and back again at some point) I expect this is possible, but as my …

Dec 23, 2008 · I want to be able to convert those 2 cells to 1 unique number. I want this as i have to create a new sheet based on startdate/starttime - enddate/endtime, for example all rows …

Aug 5, 2003 · This may clarify it. Import the file, the imported date variable would be what was in the excel file. It would be a datetime value. In your SAS code, data new; set …

Dec 11, 2001 · You could also do a CStr () on the "FormatDateTime (theDateVariable)" function to change the actual format of the date before taking the string value of it. If you want to do this in …

Jul 15, 2003 · I have a column in excel, for example column F, that has a number in each cell from a range of 1 through 25 but will very each time the program is executed. I would like to …

Jan 25, 2011 · Good afternoon, I'm extremely new to DB2. I don't know how to convert a serial date to a common date format. The database I am trying to pull data from uses a serial date …