Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with the algorithm
Message
From
04/03/2009 04:18:16
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01385379
Message ID:
01385404
Views:
49
>Hi everybody,
>
>I have a Notes memo field which is structured like this
>
>UserName: ttoc(datetime())
>Actual Notes
>
>UserName: ttoc(datetime())
>Another Note
>
>I want to be able to extract Notes for specific period of time. What would be the best algorithm here?
>
>Thanks in advance.

the best is change metadata and put ttoc(datetime()) into a separate field.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform