Date and form format masks are different during query
26875Feb 2 2009 — edited Feb 2 2009Dear friends,
I created a form which queries a database table, which has a datetime field.
During user input, user can type a date inside a datetime field, in DD/MM/YYYY format. However this datetime field is being processed as DD-MON-YY inside the form (american date format), and the database tries to query it as DD-MON-YY in brazilian date format.
This means that, although user types 02/02/2009, my form handles it as 02-FEB-09 (with FEB obviously meaning FEBruary), but it seems to me that my database is configured to query dates in brazilian date format, where 02/02/2009 is 02-FEV-09 (FEV = FEVereiro).
Is there a way for me to make my form detect datetime format being used in the database, and handle both so one can automatically be compatible with other? Sorry, I know this is simple, but I am having some trouble.
Best regards,
Franklin