=(YEAR(G4)-1900)&TEXT(G4-DATE(YEAR(G4),1,0),"000")
I used this when I had a pile of data I was inserting into a jde table with sqldeveloper import.
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...
2 comments:
This is exactly what I need. How do you convert in the opposite direction, I.e. Julian to standard date?
Thanks Shannon!!
History... http://shannonscncjdeblog.blogspot.com.au/2009/10/jde-julian-date-to-date-in-excel.html
Post a Comment