Search results

Hi, Soory I was trying to insert excel rows but I didn't manage to. I believe the context of the problem is clear. I have a table of bond prices and the time at which the price was quoted. I want to select only the last price. How can I do this using a query? below are my variables where...

Hi, I have a column of dates in text format (example: 4/15/1994) that I want to format to date numbers (34439 in the example given). Table name is "Issue" column name is "InterestDates". Any help will be appreciated.

Hi, I have a huge database where each column consists of millions of observations. one column is a column of dates but in text format (Dates1 column) and the second column is a column of dates but in a date/time format (Dates2 column). First I tried to have them in the same format by changing...

How can I fill the empty cells in a table with a number , for example "-999" or text, such as" na".