Format output using CDML?

[bhavanams]

I'm doing the search in the web.So what i want to do is ,i like to format the output values as in the current layout.I mean to say the results data should be as in the current layout.Suppose In the database the date is displayed as 12/3/1999.If i search the database in the results page it is showing the date as 1999.2/12.So can i format the output as in the layout.

Very urgent.

Thanx

[bhavanams]

Anatoli, Thanx for your reply,but even that was not working,the problem is the dates are stored as yyyy/dd/mm. So as u said when i change that using date to text, in the text field also it is displaying as yyyy/dd/mm.

I tried all the ways to get that,but nothing worked out.any one can help me.

[Vaughan]

Are the original dates stored in a date field or a text field? They shoyuld be in a date field, then you can use all the great date functionsd on them to get the data out.

If they are in a text field AND all entries are in a consistent format then some of the text functions lile Left() and Right() will be able to get the data out.

But dates should be stored in a date field.

[Anatoli]

Far easiest way is to use calculation for Date to Text and display that on HTML page.

[bhavanams]

Thanx for your replies,but i did not get the right answer,may be my question was not clear.In the database the fields types are date fields only,no doubt about it.But when i view the data in the browse mode all the dates are displayed as mm/dd/yyyy,no problem for that,but internally the dates are stored as yyyy/dd/mm.so when i do any operation on dates like searching or exporting to html tables the dates are diaplayed as stored in the database(i'e yyyy/dd/mm).This is my problem,i guess it is clear now.

can anybody help me!

Thanx for your replies anyway.

[This message has been edited by bhavanams (edited February 21, 2001).]

[bhavanams]

Thanx Cael,

But I'm sure it is the date field,and as you told,if i click the date formatted as entered option ,right below that window you can see the sample date,so there it is showing yyyy/mm/dd.So what should i do then?

And in the layout mode i tried to change the format to custom formatting like mm/dd/yyyy.Even then it did not work out.I tried almost all the ways i know,nothing worked out.I don't know why the dates are stored in that format,and i don't know how to solve that.

Thanx

sree

[CaelC]

If it is in a date field, I think it is impossible for the data to be in yyyy/dd/mm format. It has to always be entered in dd/mm/yyyy and then it can be displayed differently through a 'mask' of field formatting.

First, go to Layout mode in the DB, go to 'format' 'date' and change to 'leave formatted as entered. Now you can see your raw data and not a 'masked' display of the data.

See what that looks like. If it is other than dd/mm/yyyy, then it must not be a date field as far as I know.

Cael.

[Vaughan]

The dat can be entered in whatever format the operating system can handle.