Date Problem

Date Problem

Post by Robert Johnso » Wed, 09 Sep 1998 04:00:00



Need to take a date which is a char from one table, convert it to a datetime
date and put
the date in another table's column that is a type datetime. How do I verify
that the date is a real date before it is entered into the second table?
 
 
 

Date Problem

Post by COKEM » Thu, 10 Sep 1998 04:00:00


On Tue, 8 Sep 1998 22:39:01 +0200, "Robert Johnson"


>Need to take a date which is a char from one table, convert it to a datetime
>date and put
>the date in another table's column that is a type datetime. How do I verify
>that the date is a real date before it is entered into the second table?

You don't mention what, if any, language you are using to do this.  In
VB there is an IsDate function that will tell you what you are after.

Scott Coker                          ICQ# 11107324
**************************************************
          |/_/ |/_/
           \__/
          ~|oo~
 |\,,,,.../  y
  \        /          <----## ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
  /...    |
  \\  `~~||
   \\    ||
    hh   mm          It's that time of year again!
**************************************************
The views and opinions expressed by me
do not reflect those of KBSI.

 
 
 

1. MDX: year-to-date/month-to-date problem

I am having trouble subtracting the year-to-date totals at the quarter
through the month levels of a time dimension to
calculate the month-to-date totals.

I am using the previousmember and currentmember functions, but I cannot make
the calculation use the year-to-date
totals only at the first member of the level (January for month, 1 for
quarter).  For January, the calculation is taking the YTD amount
for the current year minus the YTD amount from the previous year, obviously
incorrect.

                                                         - Thanks, Mike
Parry (MDX novice)

2. Access table record position

3. Date problem- date calculation in between values

4. Exporting container fields

5. date problems

6. Large Unix Sun DB 12 Gig

7. MSSQL server English-Turkish Date Problem

8. manual install of sp2

9. Date problem with SQL Server

10. Date problem

11. Please Help: Need SQL Server ODBC client v3.60.x to correct a date problem

12. BCP date problems with SQL7.0

13. could date problem cause log truncation failures?