Hilsen: How about putting the logic in 4D code and then branch to the appropriate format. Intelligent formats are handy and elegant but don't have the simplicity, flexibility, or transparency of 4D code.
This sort of code is very quick to code and very easy to understand: If(length of date=5) use format with leading 0 Else use standard date format End if -- Douglas von Roeder 949-336-2902 On Tue, Jan 29, 2019 at 3:45 AM 4dialog via 4D_Tech <4d_tech@lists.4d.com> wrote: > I need to build a excel document where born date (6 char) needs to be > number > format with leading zero if only 5 chars. > How can i do this in XLS plugin, what command, what params. > There is many format commands but cant find any documentation on them with > explanation? > > > > ----- > Hilsen > -------------------------------------- > Helge Antonsen > www.4dialog.no > -- > Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
