Recent content by dontknow

thanks for the remind, I'm still trying to figure it out.

Hi Art, thanks for the suggestion. I tried to just change the data type from text to date, but it didn't work and I'm at the risk of loosing all the data. I tried to use the second suggestion you provided, I set up a new module and copied the function, however, I got lost in the query...

Hi Brian, I tried your suggestion, but it showed "data type mismatch in criteria expression". I don't know whether there's something wrong I did, I selected "createdata" in the "update to" field" in the query. any solution? thanks!

I set up a database, there's a file i originally set up as text and the format was defined as "99\->L<LL\-0000;;_" so that the date can be entered as 12-jun-2008. however I realized that it's impossible for me to do any query with this format. I was wondering whether it can be converted to date...