>Naomi:
>
>THe mdate1 and Mdate2 is a date format that is take in from the GUI I have to converted because the resulting view have the date format in 0000-00-00 instead of 0000/00/00 so the final view is in string format instead of date format.
Do both produce the exact same result (for these dates) in IDE/EXE?
Can you add more tests (you can log info into log file) if you don't want to use wait window/messagebox/browse technique to troubleshoot.
If it's not broken, fix it until it is.
My Blog