onecolor Posted March 30, 2003 Share Posted March 30, 2003 Hello, I have a field called "Start Date", in FM the field is defined as "Date", I have my format as "Thu, Dec 25, 1997". When a user enters the date on the web page, it is sent over as "12/25/1997". In my FM file the date is displayed correctly (Thu, Dec 25, 1997), but when I pull a report (over the web) that has the "Start Date" from a CDML file, the date is sent back as "12/25/1997", how do I get the date pushed back as "Thu, Dec 25, 1997" (into my web page). I would greatly appreciate any help, I'm too embarrassed to say what I've done to make this work (lets just say my date field is "text" and I have a "case" statement), but now I really need this field to be a "Date" field. Paul Link to comment Share on other sites More sharing options...
Garry Claridge Posted March 30, 2003 Share Posted March 30, 2003 Try using: [FMP-Field: Start Date, format] Good Luck. Garry Link to comment Share on other sites More sharing options...
Anatoli Posted March 30, 2003 Share Posted March 30, 2003 I believe I was first to point to undocumented "format" feature Before I discovered that I was creating text calculation field for any data format I wish. There was/is problem with entering data, because WC recognizes only US data format in some operations Link to comment Share on other sites More sharing options...
onecolor Posted March 31, 2003 Author Share Posted March 31, 2003 I'll give this a try on Monday morning. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7857 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now