I always use a javascipt calendar for the client side and passing the dates to sql in the yyyy/mm/dd format stops it from mucking up the month and day ..
Jason Sheedy On Tue, 15 Feb 2005 17:28:08 +1100, George Lu <[EMAIL PROTECTED]> wrote: > > This may help. It works for me. > > <CFSET DateConverted = > ListSetAt(Form.projectDate,2,MonthAsString(ListGetAt(Form.projectDate,2,"/")),"/")> > <CFSET SQLDateformat = DateFormat(DateConverted, "dd/mmm/yyyy")> > > Cheers, > George > > >>> [EMAIL PROTECTED] 15/02/05 16:37:52 >>> > > Got some problems with dates... > > I have a form that is requesting dates in the format dd/mm/yyyy. I want > to do the following: > > 1. I want to validate server side that they are enterring a valid date in > the format above > 2. I want to make sure that when inserted into the database that the > months and days don't get swapped around > > Any help would be great. > > Thanks Jason. > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > > AMES (Adult Multicultural Education Services) > www.ames.net.au > > > Disclaimer > ________________________________ > This email and any attachments may be confidential. > If received in error, please contact us and delete all copies. > Before opening or using attachments you should check them for viruses > or defects. > Regardless of any loss, damage or consequence, whether caused by the > negligence of the sender or not, resulting directly or indirectly from > the use of any attached files our liability is limited to resupplying > any affected attachments. > Any representations or opinions expressed are those of the individual > sender, and not necessarily those of Adult Multicultural Education > Services (AMES). > > > > ________________________________ > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] Aussie Macromedia Developers: > http://lists.daemon.com.au/ > > > > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
