February 16, 200124 yr 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
Create an account or sign in to comment