Hi everyone,
I searched the forums but couldn't find the answer to my question. I need to have a date field formatted to "mm/dd/yyyy" and I cannot use the calendar from the general tab because the field is for birth date (which would require many many clicks for any adult age).
How do I change the date format to mm/dd/yyyy in my form without using the calendar?
Thanks
Jose
I searched the forums but couldn't find the answer to my question. I need to have a date field formatted to "mm/dd/yyyy" and I cannot use the calendar from the general tab because the field is for birth date (which would require many many clicks for any adult age).
How do I change the date format to mm/dd/yyyy in my form without using the calendar?
Thanks
Jose
Hi baxterdown,
I'm nto sure I understand the question. Create and input field and validate it? I think that the validate-date may be US style, if not you'll need a custom validation (or a server side one).
You may then need to re-format the data to save it as a data in the database table.
Bob
I'm nto sure I understand the question. Create and input field and validate it? I think that the validate-date may be US style, if not you'll need a custom validation (or a server side one).
You may then need to re-format the data to save it as a data in the database table.
Bob
Hi Bob,
Thanks for your reply. I don't need validation and I don't need to keep data. This is a simple form who's information gets e-mailed to the customer. This is what I did: I created a form with a text field using the wizard. On the right side, I checked "Required" and "Date," which naturally means the field cannot be empty and the information entered must be a date.
The problem is that CF forces the user to enter the date in yyyy/mm/dd format (1946/12/21), which is not standard in the US. Americans are used to entering dates in mm/dd/yyyy format (12/21/1946). A supposed solution I have read about in the forums is to use the calendar from the CF general tab. This is not a solution for me because the field is for birth date, which means that users would have to click five hundred? six hundred? times on the calendar's left arrow to get to dates in the 1960's and 1950's.
So, my question is, how do I leave the field from the wizard as is, but change the format from yyyy/mm/dd to mm/dd/yyyy? I'm attaching a screen capture from the form so you may see what I mean.
Jose
Thanks for your reply. I don't need validation and I don't need to keep data. This is a simple form who's information gets e-mailed to the customer. This is what I did: I created a form with a text field using the wizard. On the right side, I checked "Required" and "Date," which naturally means the field cannot be empty and the information entered must be a date.
The problem is that CF forces the user to enter the date in yyyy/mm/dd format (1946/12/21), which is not standard in the US. Americans are used to entering dates in mm/dd/yyyy format (12/21/1946). A supposed solution I have read about in the forums is to use the calendar from the CF general tab. This is not a solution for me because the field is for birth date, which means that users would have to click five hundred? six hundred? times on the calendar's left arrow to get to dates in the 1960's and 1950's.
So, my question is, how do I leave the field from the wizard as is, but change the format from yyyy/mm/dd to mm/dd/yyyy? I'm attaching a screen capture from the form so you may see what I mean.
Jose
Hi Jose,
I think that there are at least two threads here about turning on the year selectors in the calendar. You can alse set a default date which will help a little. But I do agree that the Aeron Calendar is not the best for older dates.
I also think that someone - maybe Max - posted a custom validation here for mm/dd/yyyy, if not it's pretty easy to write one.
Bob
I think that there are at least two threads here about turning on the year selectors in the calendar. You can alse set a default date which will help a little. But I do agree that the Aeron Calendar is not the best for older dates.
I also think that someone - maybe Max - posted a custom validation here for mm/dd/yyyy, if not it's pretty easy to write one.
Bob
Hi Bob,
The year selector won't help. Someone who is 50 years old would still have to click 50 times to get to their birthdate. Regarding writing a custom validation, that's easy for you to say. Unfortunately, I know NOTHING about programming so I wouldn't know where to beging to write... :?
I searched for Max's custom validation and I couldn't find anything related to what I want to do. I do not need validation, and I do not want to use the calendar. All I want is a simple change to the field's format as it shows above. How do I do that?
The year selector won't help. Someone who is 50 years old would still have to click 50 times to get to their birthdate. Regarding writing a custom validation, that's easy for you to say. Unfortunately, I know NOTHING about programming so I wouldn't know where to beging to write... :?
I searched for Max's custom validation and I couldn't find anything related to what I want to do. I do not need validation, and I do not want to use the calendar. All I want is a simple change to the field's format as it shows above. How do I do that?
This topic is locked and no more replies can be posted.
