Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending dates from a sdf file
Message
From
05/01/1999 01:04:32
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00171999
Message ID:
00172656
Views:
29
>Strictdate was set to 1, the default, but the behavior is the same when I set it to 0. With date set to mdy, appending a nn/nn/nn date doesn't give me a century. With date set to ymd, it gives me a century for a 20th century date (and gives me the right date) but reads a 21st century date as mdy (no century and wrong date).
David,
Strictdate or other date settings has nothing to do with SDF date appending. Fox always expects SDF dates to be in YYYYMMDD format. If data doesn't respect this format then you should first take it as char then convert at your own or get data line by line with lowlevel functions, doing conversion on the fly.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform