DateTime Format

I declared one element in my XML Schema as "xs:dateTime", when I validate the 
XML with the date in the format "dd/mm/yyyy", it shows the error that the 
give value is not valid, so my question is how to change the date format in 
XML Schema ?? 

Please, help me in solving the problem

-- 
Regards,
Prashant C
0
PrashantC (5)
8/17/2007 1:58:01 PM
dotnet.xml 7266 articles. 0 followers. Follow

1 Replies
621 Views

Similar Articles

[PageSpeed] 42

Prashant C wrote:
> I declared one element in my XML Schema as "xs:dateTime", when I validate the 
> XML with the date in the format "dd/mm/yyyy", it shows the error that the 
> give value is not valid, so my question is how to change the date format in 
> XML Schema ?? 

xs:dateTime means yyyy-mm-ddThh:mm:ss.sss plus optional time zone 
information, see <http://www.w3.org/TR/xmlschema-2/#dateTime>.
There is also xs:date which has format yyyy-mm-dd 
<http://www.w3.org/TR/xmlschema-2/#date>.

-- 

	Martin Honnen --- MVP XML
	http://JavaScript.FAQTs.com/
0
mahotrash (1778)
8/17/2007 2:07:30 PM
Reply:

Similar Artilces:

formatting pictures
About two years ago I used Microsoft Publisher to edit some pictures. I blurred the outside edges, for example. I can not figure out how to do it again. Can anyone help me? Thanks in advance. Paula Could it have been Home Publishing? Publisher is not a photo editor although it can do some basic things. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "supermom1414" <supermom1414@discussions.microsoft.com> wrote in message news:1370685A-AE13-4014-8053-C542434B17D0@microsoft.com... > About two years ago I used...

Format a worksheet to carry out all calculations to 2 decimal plac #2
Hi, Is it possible to format am excel worksheet or whole workbook to carrry out all calculations to 2 decimal places (ie. rounding up and down)? The problem I have is that I use Excel to track expenses tha are also enetered in an accounting package and get rounding errors as excel doesn't round calulations up or down while the acounts package does. I can get excel to display to two decima places and round an individual value to 2 places, but don't know how to get teh whole worksheet to calculate to 2 decimal places. Thanks, Phill. yes it is possible. select the whole sheet ...

Keep Source Formatting
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Hello, I am trying to copy content from a website and paste it into word, and retain italicized words so I don't have to format the document by hand. How can I do this? I've searched online and I keep finding info saying that a clipboard icon should pop up when you paste into Word, and then you can click on "keep source formatting," but the icon is not popping up!? I went into Word > preferences and the "paste options" preference is clicked on. Help! Thanks! Hi, first of all, go to Word>Preferences,...

Cell Format #3
I have come across a weird situation. I am running Excel 2000 and I have come across this problem on both the XP and 98SE platforms. When I open a spreadsheet report with several columns of data (sales, units, item numbers, item category, etc...) one particular dataset an item category number set comes in as General (in terms of Properties) and the number is aligned on the left side of the cell. If I write a formula (ie vlookup) that references this cell I get an N/A. If I overtype the number (a five digit number beginning with 0, but only the last 4 digits are visible in the cell) the pro...

Imported Formats
Our Accounting package exports to Excel but the fields are all preceded with the Left Justification character, ie: " ' ". How do I find all these and replace them. The Menu Item Find says they do not exist. Thank -- Message posted from http://www.ExcelForum.com Charles, Select all your cells and run this macro: Sub MacroForCharles() Dim myCell As Range On Error Resume Next For Each myCell In Selection myCell.Value = myCell.Text Next myCell End Sub HTH, Bernie MS Excel MVP "CharlesF >" <<CharlesF.15basd@excelforum-nospam.com> wrote in message n...

how do I format a cell to validate for an e-mail address ( @ .com.
how do I format a cell to validate for an e-mail address ( @ .com, net, gov, etc) I want to make sure the user is entering a valid type of e-mail address. -- Thanks, CTaylor There are a lot of domain extensions if you consider international. With the list of extensions in A1:A100, select the target cell, go to Data > Validation, under "Allow" select "Custom" and put: =SUMPRODUCT(--NOT(ISNA(MATCH("*@*"&$A$1:$A$5&"*",D1,0)))) >0 HTH Jason Atlanta, GA >-----Original Message----- >how do I format a cell to validate for an e-mail...

Suppressing auto format in Excel
I have a .CSV file that is automatically generated by a program. Apparently, when the file is opened with Excel, the numeric fields that are enclosed in double quotes in the file and look like "123,456.1234" are being formatted by Excel and displayed with only 2 decimals. The cause of the problem seems to be the comma in the number, which I don't really want to remove. Is there any way to suppress automatic cell formatting in Excel, so the contents could be displayed just the way it appears in the source file? In the Text import wizard - step 3 of 3 - select the offending colu...

datetime to datetime offset
We are in the process of upgrading our systems entirely. Making huge changes to the hardware and software. One change is going from SQL Server 2000 to 2008. 2008 has the new datetimeoffset data type, which for us could be a God-send. In reading online however, it seems that the date time is always passed in as a string. Is there no function that allows us to pass in a datetime and an offset or do we actually have to do as I have seen all over the the Internet and convert our dateTime values to a string, then concatonate the offset and pass it in that way? If we DON'T ...

Conditional Format....IF
have a RANK formula to look at a list of numbers and return its position. (league Table) These cells have a conditional format attached where the cell ranked first (1) is filled yellow (Gold?). My problem is I want to colour the cell gray (silver) if the cell is second (2) and bronze for third. Any ideas on how this would be done????? Maybe the LARGE function would work as your Conditional Format formula Vaya con Dios, Chuck, CABGx3 "wayne" <anonymous@discussions.microsoft.com> wrote in message news:23a501c41855$42512f00$3a01280a@phx.gbl... > have a RANK formula ...

Clear Formatting in Excel
Where is the Clear Formatting button located at in Excel? It doesn't appear to be visible on the Home Ribbon like it is in Word. Hi, Maybe your looking for:- Home Tab|Styles|Conditional formatting|Clear rules -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Josh Doten" wrote: > Where is the Clear Formatting button located at in Excel? It doesn't appear > to be visible on the Home Ribbon like it is in Word. Check out this lin...

Vlookup and Formatting
On Sheet1, I have data with cells that have different formatting (e.g different text colors/bold/etc.). On Sheet 2, I have a vlookup formul that shows the data presented on Sheet 1, but without the formatting. Is it possible while using a vlookup formula to display both the dat and the data's original formatting? If not, how else can I accomplis this? Thanks!! -- peter_river ----------------------------------------------------------------------- peter_rivera's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2449 View this thread: http://www.excelforum.com/sho...

Comparing DateTime ?
i want to compare 2 DateTime. I use mktime and difftime for comparing. If I compare 2 DateTime of same year it works fine but if both dates are from different year , I get a wrong result. any idea ? >i want to compare 2 DateTime. I use mktime and difftime for comparing. > >If I compare 2 DateTime of same year it works fine but if both dates >are from different year , I get a wrong result. Wrong - how? Give us a short code snippet example of what you're doing, the values involved, and the results you're getting. Dave I get the date and time in the format ex : 10:45:4...

Format Question
Hello! I am trying to set cell A5 = A1 + A2. The problem that I encounter is Cell A1 is all text and Cell A2 is a Julian Date that I converted to form of 5/1/2005. When I try to set Cell A5 = A1+A2 I lose the Date Formatting and Cell A5 brings over the text and the julian date. Any way to do this? -- donl ------------------------------------------------------------------------ donl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21006 View this thread: http://www.excelforum.com/showthread.php?threadid=379620 in cell a5 type in =a1&MONTH(a2)&...

lose text formatting when copy text from one cell to another
I have a case where a single cell has a bunch of text in it. Some of the text is in red. Some is in blue. When, I select and copy portions of text from the cell and paste into the middle of another cell, I lose the color and other text formatting. The key here is that I'm only selecting a PORTION of the text in a cell and then trying to paste this portion into the middle of the text in another cell. If I copy an entire cell and paste it in to another whole cell, the formatting is not lost. It seems that Excel really dumbs down, formatting-wise, when I'm cutting and pasting PORTIO...

Countif and conditional formatting
I have now sorted the counting issues on the cells I have so I can extract occurences within date ranges. These dates are for various projects in the rows and basically forecast in time periods. However, how can I assign their individual project name to them when they are extracted so instead of the number of occurences for a particular date, it would for example extract 1 as Project 1 from a particular cell(B2 perhaps) then indicate another occurence from cell Y23 as Project2, so I can see which stages fall on which dates. Many Thanks, SLKPM ...

unknown xslt function "format-dateTime"
Iam using Beta2 of VS2005 and getting the error "Error 4 'format-dateTime()' is an unknown XSLT function" at the following line: <xsl:value-of select="format-dateTime($pubDate,'[FNn] [D] [MNn] [Y] [h]:[m01] [PN]')" /> how can I get around this? > > Iam using Beta2 of VS2005 and getting the error "Error 4 'format-dateTime()' > > is an unknown XSLT function" at the following line: > > format-dateTime() is XPath2.0/XSLT2.0/XQuery1.0 function. VS2005 only > supports XPath1.0/XSLT 1.0. Use ms:format-date() exten...

xsd restriction on dateTime based on other dateTime
Hi All, i'm trying to define an xml schema for validation with a restriction on dateTime element based on another dateTime Element. in English: end (dateTime) should be greater than or equal to begin (dateTime) Is it possible to define such restrictions in XSD? regards Joris van Lier Joris van Lier wrote: > i'm trying to define an xml schema for validation with a restriction on > dateTime element based on another dateTime Element. > > in English: end (dateTime) should be greater than or equal to begin > (dateTime) > > Is it possible to define such rest...

conditional formatting: multiple conditions with min
Hello, I am using Excel 2007 and I am having an issue with conditional formatting. I have 2 columns of data that I'm working with: Column "c" which contains both names and some empty cells, and column "i" which contains dates and some empty cells. If there's a name in column c then there is definitely a corresponding date in the same row in column i. However, there are sometimes blank cells in column c dates that have dates in column i and some rows that have blanks in both c and i. See the following example: Sue --- 10/1/2010 ___ --- 10/1/2010 Joe --- 10/23/2010 ...

Cell format
I have a set of cells that show the fraction of #complete/#total. They are formatted as fractions so that I can custom format them such that those >=50% turn green and those <50% turn red. The problem is that for a completion of say 8/10, excel automatically simplifies to 4/5. Is is possible for excel to still recognize the cell as a fraction but not simplify? Format Custom as ?/10 -- Kind regards, Niek Otten Microsoft MVP - Excel "Matt" <MLThornton@gmail.com> wrote in message news:1168123040.807871.37450@i15g2000cwa.googlegroups.com... |I have a set of cells that...

How to change an entire row using conditional formating
Hi.. I am trying to make the text of an entire row go a different colour (light grey) when a specified cell is equal to a given value (in my case the letter ‘Y’) I can easily do something similar using the ‘equal to’ condition in the ‘Conditional Formatting’ functions, but this will only work on the one cell and not an entire row.. Can anyone write me the function or correct Conditional Formatting for this to work ..? Thanks in advance ..J Hi - select your row (lets say row 1) - goto the conditional format dialog - choose 'formula is' - enter something like =$A1="Y&quo...

C# DateTime -> XML DateTime
Is there a method available to convert a C# DateTime format to XML DateTime format? Thanks, Guy Have you looked at the XmlConvert class? --Dare -- This posting is provided "AS IS" with no warranties, and confers no rights. "Guy Dillen" <guy_dillen@hotmail.com> wrote in message news:3f5f632e$0$13863$ba620e4c@reader0.news.skynet.be... > Is there a method available to convert a C# DateTime format to XML DateTime > format? > > Thanks, > Guy > > yes i have looked at this lass, but does this also work in the direction C#->XML? "SQ...

Putting " &" in the caption format property of Option group
Hello: I have not been succesful in trying to make a filter on filter on my main and subform. I am seriously studying the sample on the Northwind sample database's "Customer Phone List" My question is what is the function of puttting an "&" in the caption format property. In the button "A" for example, in caption property it says " &A", waht is the function of &. Can anybody help me? maybe because I do not put it in my form that caused it does not work. Thanks in advance. Frank In news:A55DE234-9E53-43F5-B3E0-8313962383B9@micros...

how do i use multiple conditional formats in one cell?
I need to make difrent "words" in one cell make number values in a difrent cell tyson CF will allow up to 4 formats per cell, including the default format. However, CF will not place number values in cells. Can format only as in Fonts, Borders and Patterns. What would you like to have done? Perhaps there is another method. A worksheet function such as one of the LOOKUP functions or MATCH. Gord Dibben Excel MVP On Fri, 21 Jan 2005 14:55:03 -0800, "tysonstone" <tysonstone@discussions.microsoft.com> wrote: >I need to make difrent "words" in one ...

Format Axis not available
I've created 4 graphs of simlar data and pasted the 4 into a single chartsheet. I'm now polishing them up for a presentation. But on 2 of the graphs, I can right click in the x axis, which is at the top, and get "format axis" and make changes. On the other 2, I cannot get the "format axis" option to show, now matter how many times I try. Does anyone know what the difference is? Why in some graphs, and these are all horizontal bar graphs created the same way, format axis is an option and why in others it's not. The only thing I can remember doing different as I c...

CAPS and Date/Time formatting
Hello! I'm hoping the discussion group can advise me on a couple of formatting issues- I have a State field that is 2 characters with a format of " >". Great for data entry, but when the State in pulled into a report, the State does not appear in all capital letters. What is the correct formatting for all caps? I have a Date/Time field with this formatting: =(Format$([SchedDate],"Long Date",0,0) & " at " & (Format$([ShiftStart],"Medium Time"))) which gives me: Sunday, July 08, 2007 at 09:30 AM How can I format for: Sunday, July 8, ...