Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Converting Date functions

  Asked By: Lorenzo    Date: Dec 28    Category: MS Office    Views: 880
  

I am trying to create a SQL statement in Excel and my update statement
is as follows:


UPDATE M_DIMENSION1206294 SET A_WEEKNUM = 117 WHERE A_WEEK = '38500';


Unfortunately, I am trying concactenate a Date Field into the
formuala, but Excel is converting date to a numericac value of 38500.

That date is actually sitting in cell A2.

How can I edit my statement to use the date instead of the numeric
value?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Rayner Fischer     Answered On: Dec 28

Just use Format(<cell value>,"yyyy-mm-dd") - or whatever format is appropriate
for your database.

Dates are always stored internally as numbers like this. You need to format
them appropriately for output.

 
Didn't find what you were looking for? Find more on Converting Date functions Or get search suggestion and latest updates.




Tagged: