sabine.hubri...@t-online.de
unread,Apr 5, 2013, 10:06:03 AM4/5/13Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to xs...@googlegroups.com
Hi,
I'm new to this forum so sorry if I do anything wrong for a start ...
in fact I'm not even sure if it is the correct group but as I'm looking for the right technical idea in xslt, not for something in the resulting "language" for excel, it might be.
I'm generating an Excel-Output in Office Open XML format, that is all the files that belong to the *.zip which is used as *.xlsx, using some of my own *.xslt which parse some input.xml with data which cannot be imported directly . . .
I get some strings representing a date, like 2015-12-19
I know (from ZVON.org or W3.org), there are quite some functions which handle xs:dateTime as well as stingmanipulating functions like substring-after... which would fit to extract the year,month,day ... but still are string-related.
What I need is to calculate the effective numeric value of such a date, in the above example that would be 42357, in the algorithm Excel uses starting with 1.1.1900 (at least I seem to remember having read that being the startOfTheWorld ;-) )
Do I really have to calculate that on my own?
I cannot believe that nobody else would need such a thing and that there's no such function somewhere already ;-(
so thanks for any help,
bine