Re: Date function/Text issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Tue, 6 Dec 2005 05:52:02 -0800, "MijC" <MijC@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

>2. Data is downloaded from our IT database. (I have spoke to them several
>times on this issues yet no resolve) It would be recorded at the time of the
>transtaction there is a date/text stamp used. How it get thre I am not 100%
>sure. Will try to find out. (I know this is the issue, but I need a work
>around until this is fixed, if ever)

If that is the case, I think the work around should be to convert the TEXT
strings to real dates.

Let's try a few things.

1. With one of the strings were ISTEXT(cell_ref) = TRUE
1. Copy/Paste into your response the contents of the cell.
2. What is the result of the formula =LEN(cell_ref) ??
(This should tell us if there are any non-printing characters).

2. What happens if you prepend a double unary (--) to the TEXT strings? (i.e.

=--11/13/2005 00:08:03

That might force the string to become a true date/time (number) and, if
it works, we can use a much simpler procedure to apply it to everything. If
that does not work, then the results of procedure 1 above will become
important.


--ron
.

Relevant Pages

  • Re: WXP SP2 Woes
    ... Hotfix to resolve your error regarding the strings section being too long. ... Client Security Rtvscan ... > add these missing settings (they are fully described in the white paper ...
    (microsoft.public.windows.server.sbs)
  • Re: [ANN] Data Source Name parser (ODBC etc.)
    ... > suggested URL-like strings describing database connections. ... > library for such strings (data source names) is now available at ... raises the exception Syntax_Error. ...
    (comp.lang.ada)
  • Question on how updates to Access tables may or may not cause the database to expand in size
    ... All strings are stored as variable length data, one byte for each actual character and one overhead byte. ... When a database is compacted and repaired, tables are written out in primary key sequence. ... I have concluded that after the compact/repair, that each table, is written in sequence, filling up 2k pages, and that tables are not generally intermixed except at the end of one table and the beginning of the next. ... then the database DOES expand in size. ...
    (comp.databases.ms-access)
  • Re: FYI: F# language moves from lab into production
    ... unpacking the metadata into a different form seems possible, ... format (basically, a windows-registery style heirarchical database), either ... based around linked-lists of nodes, key/value pairs, and interned strings). ...
    (comp.lang.misc)
  • Re: Japanese to Unicode characters
    ... Oracle-Rdb database; a VB application running on a Window98 Japanese PC ... store the japanese strings as Unicode. ... UniToolBox component for VB which handle the Unicode strings. ...
    (microsoft.public.sqlserver.programming)