Hmmmm....you're going to have to manipulate that date somehow before you try to format it.
How does the date come over from the form? Is it a free text field where they type in the date? You're going to have to parse out the day month and year from that somehow. I don't know of any way around it. Let me know how the date is formatted, and I might be able to help you more. I really don't think there is another way. Ray At 11:16 AM 11/12/2004, you wrote: > >You have to create the date first. > > > >Try this: > > > >#LSParseDateTime(LSDateFormat(CreateDate(2004,12,1)))# > > > >Ray > > > >At 11:02 AM 11/12/2004, you wrote: > >> >In reality the date is being passed in a form variable because this is the >data that the user has entered so would the createdate not apply here? So >my original code should have read; > >#LSParseDateTime(lsdateformat(MyFormFieldDate, "DD MMM YYYY"))# > >I hope I am not confusing this too much! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184150 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

