>? CTOT("20050131120100")
>
>Returns a blank DateTime value
try:
TimeStr = "20050131120100"
DATETIME(VAL(LEFT(TimeStr,4)),;
VAL(SUBSTR(TimeStr,5,2)),;
VAL(SUBSTR(TimeStr,7,2)),;
VAL(SUBSTR(TimeStr,9,2)),;
VAL(SUBSTR(TimeStr,11,2)),;
VAL(RIGHT(TimeStr,2)))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.