| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert american dates from a query
Your correct - my mistake on this with regards to not recognizing "DEC".
check out Stephen Bullens chapter on international considerations for suggested solutions: http://www.oaltd.co.uk/ExcelProgRef/ch22/ -- Regards, Tom Ogilvy "Mika" wrote in message ups.com... Thanks for your interest Tom, They don't work because those functions accept the argument as along as it is recognised as a valid expresion of a date, and that I guess is related to the regional settings... In the non american excel they will give an error: type mismatch. what I need is a function that "knows" it always receive and american date... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
| convert american dates from a query | Excel Programming | |||
| How do I convert spreadsheet from Canadian $ to American $? | Excel Discussion (Misc queries) | |||
| English and American dates... | Excel Programming | |||
Threaded Mode
