I have an integer, but that is yyyymmdd and has nil to do with the Excel integer date format. Did you try putting a value in the integer format yyyymmdd in Excel and have it as a normal Excel date? Or did you try it with a string in the format dd/mm/yyyy? Come to think of it, maybe I should make it mm/dd/yyyy with the SQLite function substr.
RBS -----Original Message----- From: Fred Williams [mailto:[EMAIL PROTECTED] Sent: 03 December 2006 17:11 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Dealing with dates in the format yyyymmdd Still don't understand the issue. Excel stores the date internally as the integer as you describe, no matter how you chose to format the cell's display. Changing the display format does not change the cell's internal format. And to the best of my knowledge changing Excel's internal cell storage structure is not possible. Fred > -----Original Message----- > From: RB Smissaert [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 03, 2006 8:56 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Dealing with dates in the format yyyymmdd > > > I am familiar with Excel and I have tried that but it doesn't work. > I find the only reliable way to put dates in Excel is to put > the integer > Excel date in like for example 39054 and then set the date > format in the > sheet. > > RBS > > -----Original Message----- > From: Fred Williams [mailto:[EMAIL PROTECTED] > Sent: 03 December 2006 14:41 > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Dealing with dates in the format yyyymmdd > > Is there a reason you can use Excel's "Format Cells" to > accomplish what > you wish? Enter a "Custom" format of "yyyy\mm\dd" in a cell and enter > "=today()" as a value in that cell. Have not fooled with Excel much > lately, but I think you can even format a spreadsheet > programmatically. > > Fred > > > -----Original Message----- > > From: RB Smissaert [mailto:[EMAIL PROTECTED] > > Sent: Sunday, December 03, 2006 8:21 AM > > To: sqlite-users@sqlite.org > > Subject: [sqlite] Dealing with dates in the format yyyymmdd > > > > > > When moving data from Interbase to SQLite I have to convert > > integer dates in > > the format yyyymmdd to Excel dates. These are integer numbers > > counting the > > days past 31 December 1899. With substr I can make it > > dd/mm/yyyy (I am in > > the UK and that is the normal way to format dates) but the > > problem is it > > will be displayed in Excel like mm/dd/yyyy if that would be a > > possible date. > > This is due to the US date format of Excel. > > So, would it be possible in SQLite to make a date format like this: > > dd/mmm/yyyy so that would be 03/dec/2006 > > This would prevent Excel from putting the month first. > > or alternatively make it the Excel integer date format so the > > above date > > would be: 39054 > > > > I could handle the date formatting in VBA, but I would like > > to do as much as > > possible in SQLite as it will be faster and it would keep the > > code neater. > > Thanks for any advice. > > > > RBS > > > > > > > > > > -------------------------------------------------------------- > > --------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > -------------------------------------------------------------- > > --------------- > > > > > -------------------------------------------------------------- > -------------- > - > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > -------------- > - > > > > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
