Harley84
asked on
Show data in british time format
I am hosting my site on an american host and i need to display dates in british data format but it wont, any ideas? Also i dont know if this has anything to do with it but when i insert dates into the database (access 2000) it gives me a ramdom data and a time also - why?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you using a combo drop down to insert dates or a calendar, or are you manually typing them in?
Show daata with this:
Function formatToUK(v)
formatToUK= day(v) & "/" & month(v) & "/" & year(v)
End function
Put in DB with this:
Function formatToUS(v)
formatToUS= month(v) & "/" & day(v) & "/" & year(v)
End function
Function formatToUK(v)
formatToUK= day(v) & "/" & month(v) & "/" & year(v)
End function
Put in DB with this:
Function formatToUS(v)
formatToUS= month(v) & "/" & day(v) & "/" & year(v)
End function
ASKER
Problem solved, thanks alot. You were right i hadnt specified the input mask, thats all it was, its works as its supposed to now - thanks dude!
Put this in your code to display british dates