Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The Date Field

Status
Not open for further replies.
merc500sl

merc500sl

Programmer
Jan 31, 2000
3
CA
I am using Visual FoxPro 3.0 and 5.0 but there seems to be a problem with my date fields. When I do a comparison with two date fields (both 2000), it give me the wrong output.<br>
<br>
Could there be a problem with the way I am defining the date fields? Please help me out...
 
Sort by date Sort by votes
Visual 3.0 did/does have a error in the date field. The problem will migrate to V5.0 if the database(s) were created in V3.0. The problem stems from the Set Century on command. If one date is saved with set century off and another date is saved with set century on and the dates will not compair correctly.<br>
<br>
Try this. <br>
set century on<br>
use Database<br>
replace all date_field with date_field<br>
(do this for each date field you have in the database)<br>
then do the date compair and see if it works correctly.<br>
<br>

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Dusanga
  • Locked
  • Question
Automatic date completion
Replies
8
Views
911
mJindrova
mJindrova
SitesMasstec
  • Locked
  • Question
Set a TAG for a field programmaticaly 3
2
Replies
29
Views
2K
SitesMasstec
SitesMasstec
GriffMG
  • Locked
  • Question
wwIPstuff - Ionos not accepting Date: header value
Replies
15
Views
1K
Piotr Czekalski
Piotr Czekalski
1962dez
  • Locked
  • Question
Control Date/Time 2
Replies
10
Views
736
atlopes
atlopes
CBellucci
  • Locked
  • Question
Inserting Image into varbinary(max) field 1
Replies
11
Views
1K
Joe Crescenzi
Joe Crescenzi

Part and Inventory Search

Sponsor

Back
Top