Getting a date from .txt file or variable

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Getting a date from .txt file or variable

Message

From

07/07/2008 12:41:54

Borislav Borissov
Microcomplex
Sofia, Bulgaria

07/07/2008 12:29:04

Tore Bleken (Online)
Vear, Norway

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: Getting a date from .txt file or variable

Environment versions

Visual FoxPro:

VFP 9 SP2

Miscellaneous

Thread ID:

01329441

Message ID:

01329467

Views:

>lcDate='04/07/2008 1054AC PRESIDENTE EPITACIO - PRESIDENTE EPITACIO/SPConferi'
>?Date(Val(substr(lcDate,7,4)),Val(left(lcDate,2)),Val(Substr(lcDate,4,2)))

I also prefer DATE function when I should convert something to date but if you have something wrong in that sting you will get error, with CTOD() you will get en empty date.

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

Map

View

Click here to load this message in the networking platform