Help desperately required re: date formatting

Can anyone shed any light here before I abandon DataAssist.......

Pretty well every time i insert records using DataAssist it has been impossible to force a UK date format - either using <%Session.LCID=2057%> or switch function code recommended by WebAssist.

WebAssist support now concede that DataAssist can't insert the date in UK format (tho it has been known to do it correctly on some insert page, for some even more baffling reason) and say there is a bug and it may get fixed at some point in the future, but that's obviously not helping me now, knee deep in a project.

I have tried re-building a basic Dreamweaver Insert page and the date inserts fine. However I also need to use Dig File Pro to upload files WA engineer thought that should be fine) . Having added that, and changed all the "Request.Form" instances to "UploadFormRequest", I am left with the page falling over at the line using "If (CStr(UploadFormRequest("MM_insert")) = "form1") Then".

It brings up the same "can't call binary read" error message. If I change that instance of "Request" to "UploadFormRequest", I get an type mismatch error.


Can anyone shed any light on a way forward? I really have to be able to input dates in consistent UK format and be able to upload files from the same page. I'm not good enough write it all without extensions

Am I asking the technically impossible or does anyone know what needs to be changed in this code that's hanging. Or how to actually ensure a UK date format adhered to....

Would be very grateful for any suggestions.

Validation Toolkit will reformat a date for you. What database type are you using? mySQL for instance only accepts Y-M-D H:M:S format.

Anybody from any region needs to use this format, not just UK, but US as well.

There are many functions and techniques for reformatting dates, but the right technique depends on your server language and database type.

Hi,

I'm using ASP and Access dBase, do you think Validation toolkit could do it?

I'm pretty sure it could with client side validation and reformatting options. I'm not sure what format dBase expects, but you could probably look that up and make sure validation toolkit updates the date to the correct format.

thanks, that could be a life-saver. any pointers on how i would start applying the behaviour to change the date format around? i can see how the validator might flag up a date as being non-UK format but where/how would you instruct it to apply some change?

thanks for any assistance ray.

Highlight the form and go to the Behaviors window in DW. Then apply the date validation behavior. It will ask the date format to use and you can set it in that interface. You can ignore the rest of the settings since all you care about is the date formatting.

ok. thanks

when i do there are two boxes - first one says "allow", second one says "reformat" - on the basis that i want people to input the date in dd/mm/yyyy format and the validator has to stop this being input as mm/dd/yyyy, what would you recommend i select as the settings for the two areas above?

Well in some cases it isn't possible, since who knows what format 11/09/2009 is in after all, but I'd probably just do it onBlur instead of onSubmit. So instead of highlighting the form, highlight the form element itself and use the onblur even.

Set both start and end date formats to: dd/mm/yyyy

See if that works for you.

no, doesnt work (file attached) . i still get 02/07/2009 reversed to 07/02/2009. the other oddity is the subsequent email generated by universal mail with the vent info does show the date as correct tho.

any other bright ideas/hackrounds/thoughts..? other than that i have to abandon DataAssist which is a massive pity cos it helped me so much.

by the way, i quite take your point that "who knows what 02/11/2009 is" - i just dont want it automatically reversed - if you understand!