=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+MID(A1,3,1),1,RIGHT(A1,3))
whack 109023 into A1 and watch that bad boy go!
Subscribe to:
Post Comments (Atom)
-
There are a heap of instructions of what you need to change if you change the IP address of your weblogic server, but I find they are not co...
-
They have been around for quite some time, but it's nice to have a refresher on these types of things. 8.12 and 9.0 have have started...
-
I’m running windows 7 virtual on OVM with office 2010. Have E1 fat boy and oracle 11G client. I’m using this machine for some BIP prototyp...
1 comment:
Shannon - found a bug in your JDE Date to Excel Date...should be
=DATE(IF(0+(LEFT(A2,2))<30,2000,1900)+MID(A2,2,2),1,RIGHT(A2,3))
- Vernon
Post a Comment