Date Formatting! Help me!

[bhavanams]

Hi guys!

I have a problem.Actually i'm doing search a filemaker database file.Afer searching,in the results page the date fields are displayed in YYYY/MM/DD format,i want to display it as MM/DD/YYYY.How is it possible using CDML .Is there anything like FMP-Field dateformat or something like that.

The problem here is in the database the date fields are stored as mm/dd/yyyy only,but why? while retrieving it's showing in the format of YYYY/MM/DD.and one more thing while searching also if i search by entering MM/DD/YYYY it is giving the error "no records found",and if i search YYYY/MM/DD it is working fine.Why is it happening,what is wrong with the database.

I have 2 database files, suppose A and B.It was all working fine with the database A,but why B is giving problems.

Can anybody Help me.

I'm desperate to know that.

Please read carefully and send me the answer.

I appreciate the solutions.

Thanx

sree

[Anatoli]

Couldn't you use Calculation fields with proper text format?