Can I coerce a decimal (float) to varchar? Also, can I coerce a date to varchar? I want to concatenate some text with a decimal value (and in another field a date value) and place it into a varch...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10948101.html
Zones:
MS SQL ServerDate Answered: 08/09/2000 Rating: 9.4 Views: 0
I am writing a stored procedure.
I would like to select a field
(type = date/time value = '11:59:35 AM')
and check to see
if it is less than 3:00pm.
If it is, then assign another field a val...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11230182.html
Zones:
MS SQL ServerDate Answered: 09/11/2000 Rating: 9.2 Views: 0
Ive got a range called DATE8HY containing dates 10.09.2000, 30.08.2000, 10.09.2000, custom formatted to dd.mm.yyyy and another range named SCORE containing nos 10, 5, 12. When I input my formula:...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_112...
Zones:
MS OfficeDate Answered: 09/12/2000 Rating: 8.0 Views: 0
How can I get the Julian Date in VBA (Access 2000)?
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_11937518.html
Zones:
MS AccessDate Answered: 11/23/2000 Rating: 8.0 Views: 0
I have a problem with Excel 97 and DSUM
I have been converting a spreadsheet from Lotus 123 to excel 97
The original spreadsheet uses the DSUM function to get the accumulate data from a colum...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_119...
Zones:
MS OfficeDate Answered: 05/23/2001 Rating: 8.6 Views: 0
Hi all
I need to tage Bithdate from from one table and calculate the age of the person using today's date and update the "age" column in another table.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_12027380.html
Zones:
MS SQL ServerDate Answered: 11/30/2000 Rating: 8.0 Views: 0
How do I count records that have a blank date field?
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20006294.html
Zones:
MS AccessDate Answered: 12/29/2000 Rating: 8.2 Views: 0
I notice that in Access 2K when I have a Date field in a Table, and I enter a date such as 14/9/00 instead of giving me an error it assume that I transversed the Month and Day and changes the date ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20009968.html
Zones:
MS AccessDate Answered: 01/21/2001 Rating: 8.8 Views: 0
i have a range of data from the validity date :
Date RATE
2000-07-31 115
2000-08-01 115
2000-08-02 115
.
.
. so on..
how can i get the data in the data in the format below??
2000...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20033328.html
Zones:
MS SQL ServerDate Answered: 01/31/2004 Rating: 7.8 Views: 0
Hi i need to create a report for a databse i have created. It is a record of customer billings. There are three payment periods, Monthly, Quaterly and Annually. Depending on the option that has bee...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20086808.html
Zones:
MS AccessDate Answered: 10/29/2001 Rating: 7.6 Views: 0
