Providing DateTime Pattern in XML schema used to create ADO record set

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Providing DateTime Pattern in XML schema used to create ADO record set

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Ask XML questions here] >> .NET programming discussions >> Providing DateTime Pattern in XML schema used to create ADO record set

Page: [1]

Message

<< Older Topic Newer Topic >>

Providing DateTime Pattern in XML schema used to create... - 10 June 2008

aayamsingh

Posts: 1
Score: 0
Joined: 9 June 2008
Status: offline

Hi,

I have a XML schema and data in a file using which i am creating an ADO record set.This ADO record set is later passed as datasource to OWC 10.
The XML schema and data contains datetime fields in them.Below is one of the attributes example used to define the schema for DateTime field.

<s:AttributeType name="D4" rs:number="4" rs:name="My datetime"
    rs:writeunknown="true">
                     <s:datatype dt:type="dateTime"   rs:maybenull="True" />
</s:AttributeType>
<rs:data>
                    <z:row D4="2/20/2006" />
</rs:data>

As we can see that there is no way i have specified the DateTime pattern in the schema.Currently we have created the XML using English(US) culture hence its M/dd/YYYY pattern.

Now i am trying to create an ADO record set using javascript at client side by loading this file in XMLDOM and then open this XMLDOM in ADO record set.This ADO record set act as datasource to OWC 10.

Now problem comes when i need to apply different datetime pattern to this OWC field.With a different pattern suppose DD/MM/YYYY then its a problem.Like
for date in MM/DD/YYYY = 12/02/2008 now OWC wont change this date to DD/MM/YYYY.But for date 12/20/2008 OWC will change this date to 20/12/2008.

So this is inconsistency between date formats because there is no way OWC know the source datetime pattern.I am assuming if somehow we could specify OWC that the datasource attached to it has date in format MM/DD/YYYY then it will able to change the format easily.
One of the way to do so i am thinking is to provide that in the XML schema and XML data that i had created earlier with and send to client side to create XMLDOM object.

Please help me if this is possible or is there any otherway i can do that.

Regards,
Aayam Singh