XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Convert date
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Use of before and after string (3) Sticky Topic
-> - How do I substitute element ty... (1)
-> + How does one add working days ... (4)
-> - Help, I have existing XLT and... (1)
-> + Need help on XSLT issue - (2)
-> + EDI to XML Conversion (7)
-> - XML To JSON Conversion using X... (1)
-> + Formatting Paragraphs to same ... (2)
-> - Grouping of records (1)
-> + Problems with xsd 1.1 (4)
-> + XML to HL7 mapping (3)
-> + XSLT 3 and Iterate (2)
-> + XSL-FO to PDF preview (3)
-> + java.lang.RuntimeException: Er... (2)
-> + Create Acroforms with Stylus X... (2)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Tony LavinioSubject: Convert date
Author: Tony Lavinio
Date: 25 Jul 2005 03:03 PM
How are you getting the date out of the database?

If the string were in an XML document or equivalent already, the
expression would be something like:

substring-before(substring-after(substring-after(., '/'), '/'), ' ')

Or, if you knew that the mm and dd were always going to be two digits,
you could use
substring(., 7, 4)

Replace the '.' in the above with the expression that resolves to the
node containing the date.
Postnext
Sravan kothaSubject: Convert date
Author: Sravan kotha
Date: 25 Jul 2005 05:39 PM
Hi Tony,

I have a text field for date in one module and a date field in other module. When i enter the yyyy in text field it is stored in database as 2005 but when i enter it from date field it is stored as 1/1/2005 00:00. The code u have sent to me works when i copy the date from date field to text field in my application but not from text to date field. Can u please help me out.

Thanks
Posttop
Tony LavinioSubject: Convert date
Author: Tony Lavinio
Date: 26 Jul 2005 10:43 AM
I'm not quite sure why the first form I gave you before wasn't
working; perhaps you could tell me what you did get for output
from it?

You could also try this:
substring(substring-after(substring-after(., '/'), '/'), 1, 4)

That will get the first four characters after the second slash.
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.