Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ashley Smith   on Aug 27 In MS Office Category.

  
Question Answered By: Salvatore Kelly   on Aug 27

You should always try to get dates in yyyy-mm-dd format. This is
unambiguous and should always be translated correctly.

Your comment

> A problem  arises, however, because the
date  in the web  query table is sometimes
> of the above format, and sometimes in the
format  01/21/2008.

is a concern, though. Why would the query  return dates in different
formats? You need to sort out the input (query) first, otherwise you are
risking a GIGO situation.

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Problem with date formats and searching Or get search suggestion and latest updates.


Tagged: