|
Date Format problem - 30-12-1899 |
 |
 |
 |
|
Written by hede
|
|
Saturday, 21 January 2012 20:15 |
|
Recently I had to work on a report containing start and end dates of
some business contracts. When I had made the extracts from the
business database I found some of the dates appeared as
30-12-1899 or 01-01-1900 in exel (Microsoft(TM)) . When I
checked my data I found that all dates in my work
sheet called 30-12-1899 - were meant to be blanks.As I could
not format my way out of it I chose to insert the following formula:
= IF((A2 >1900);A2;" ") 
The form above is simple: If the date in cell A2 is bigger
(or rather after )that year 1900 then the date is copied
into cell B2 - If not the form puts a blank. |
|
Last Updated on Friday, 24 February 2012 12:56 |
|
|
DBDesigner4 and mysql connect-problem solved |
|
|
|
|
Written by Administrator
|
|
Monday, 18 April 2011 09:49 |
|
I have earlier stated that I am an GUI freak - an almost inappropriate behavior - among true believers, however I choose to stand by GUI as I also see it as a natural development and we can not stop the world. Well I have spend some time on MY-SQL and have designed some practical databases (by hand!!!!!), however I prefer graphical tools- to command line. Looking among the graphical tools I found DBDesigner to be the most versatile tool- however getting to connect to my MY-SQL database did pose a small challenge. MY-SQL simply does not accept the password send by DBDesigner4 to the database. The solution- (or workaround -if you prefere) is that you simply have to make a MYSQL profile with NO password. In order to compensate a bit on the security side - you have to make a difficult profile name - based on random letters and numbers. In order to be on the very very safe side - you can choose to use the setup with DBDesigner and a no-password profile on a local installation for development purposes- and then export the finished result to your production environment. 
|
|
Last Updated on Sunday, 24 April 2011 10:45 |
|
My favorite Newsgroup posting |
|
|
|
|
Written by Administrator
|
|
Saturday, 07 July 2007 10:54 |
My favorite newsgroup posting Usenet newsgroup comp.os.minix, Posted some
time in august 1991 Hello everybody out there using minix- I’m doing a (free) operating system (just a hobby, won’t be big and professional like gnu) for 386(486) AT clones. |
|
Last Updated on Tuesday, 31 May 2011 08:21 |
|
|
Written by Administrator
|
|
Saturday, 07 July 2007 10:54 |
|
2008 - IT-consultant- Gladsaxe County
2007 IT-consultant - Project mng.- Copenhagen County
2006- IT-consultant Project mng. and system admin - Møbeltransport Danmark
1996- 2005 IT-marketanalyst --Finpro (formerly Finnish Foreign Trade Association) |
|
Last Updated on Thursday, 23 December 2010 12:06 |
|
|
