Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I'm working on a system for use in Thailand, where users mainly use date formats of dd/mm/yyyy. I want the user to determine the format from the system setting. I'm having a problem w/datetime values in a view. The view field is something like:
>>
>>IIF( lContact, TTOC( MadeOnDate ), SPACE( 22 ) ) AS cMadeOn
>>
>>The TTOC( MadeOnDate ) in the View is returning the date format in US format. I'm thinking that I have to write my own UDF to deal with this. Does anyone have any other ideas?
>
>
>Doesn't SET DATE BRITISH
or DMY()
help?
But if I want to let the user decide on the format (via system settings), wouldn't that force the format to British?
I want the user to decide how to see the dates, and have it mostly working, except for the view....J
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement