How do you select a date range with FoxPro 6?, I tried to use "Between" but I get syntax errors?
484857
hahaha first answer made me laugh.\n\nThat is true, no body uses foxpro, though, you migh do this:\n\nselect * from table where date>initialdate and date<enddate. This really works.
1140819
using convert functions\nCONVERT ( data_type [ ( length ) ] , expression [ , style ] )\n\nexample\n\nuse pubs \ngo\n---------------- Selecting only the date part from a datetime column --------------\n/* Creating a Test Table */\nCreate Table MyDateTest99\n(\n DateColumn datetime\n)\ngo\n\n/* Inserting the test value into the table */\ninsert into MyDateTest99 values (getdate())\ngo\n\n/* Selecting the result */\nselect convert(varchar,DateColumn,101) from MyDateTest99\ngo\n\n/* Performing Cleanup */\ndrop table MyDateTest99\ngo\n\nuse pubs \ngo\n\n---------------- Selecting only the date part from a datetime column --------------\n/* Creating a Test Table */\nCreate Table MyDateTest99\n(\n DateColumn datetime\n)\ngo\n\n/* Inserting the test value into the table */\ninsert into MyDateTest99 values (getdate())\ngo\n\n/* Selecting the result */\nselect convert(varchar,DateColumn,108) from MyDateTest99\ngo\n\n/* Performing Cleanup */\ndrop table MyDateTest99\ngo\n\n\n\nhttp://sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk
707324
Select the time or date object and click on Insert.\nChoose Date and Time and remove the tick from 'Update automatically' and click OK.  The date and time will revert to normal text.
248642
Your best bet is probably to use Perl and the Date::Calc module
573842
Download Shareaza or Limewire and put your search for Foxpro 2.6. You will find loads of material either ebooks or zip files which you can download.  \nIt is free and it is shareable.\n\nEnjoy!
8550
I recommend Ninotech Date Edit 4.0 (freeware)\nhttp://home.worldonline.dk/ninotech/freeutil.htm
760074
field: LISTID \ntype: INT \nlength: 10\nattributes: unsigned\nnull: not null\nextra: auto_increment\ncheck ON the first radio button (the one under the icon with the key picture)\n\nfield: MYDATE (do NOT use just DATE; DATE is a reserved word in MySQL)\ntype: If you are going to use this with PHP or other Unix-based programming language, you may find it easier to use Unix timestamps, in which case you would make this an INT. Otherwise, DATE\nleave all other items default / blank, unless there will be records without dates. If there will be records without dates, mark the null column NULL\n\nfield: MYWEIGHT\ntype: INT\nlength: 3\nattributes: unsigned (unless you expect negative weights)\nall other items, leave default / blank\n\nfield: MEASUREA (do not use field names that contain blanks)\ntype: FLOAT\nlength/values: 4,2 (the number before the comma is the total length of the float; the number after, the precision. This assumes a float from 00.00 to 99.99)\nattributes: UNSIGNED, unless you expect negative values\nleave all other items blank / default\n\nRepeat for 5, 6, 7, 8\n\nfield: MYBLOG (BLOG is close to BLOB, another reserved MySQL word)\ntype: LONGTEXT\nleave all other items blank / default\ncheck ON the checkbox at the end, under the icon with the T (for FULLTEXT Indexing; this will be useful if you ever want to add text searching to this field)
743627
I would use Microsoft office Access package, it is a date base.  Just take time to organise which titles you need, it is fairly simple to operate, and can be updated very easily.
54341
Not sure I understand the question. Do you mean the international date line?
260803
Hmmm...Unusual Suspects?? :)\n\nI ran into this problem a few months ago.  Couldn't be assed with writing a VBScript.  It took me about an hour to clean it up by hand (it would probably take me the same to write and debug the script).\n\nHere's the easiest way to do this by hand:\n\n\nunless you already have a backup calendar-type folder somewhere for backup, Create a new outlook data file and create a new calender folder in it \nSwitch to Folder List view in outlook\nSelect your Calendar Folder\npress ctrl-shit-f to search\nHit find now.  \nSelect All entries (ctrl-a)\nhit ctrl-c (to place a reference to all items to your clipboard)\ngo into the backup folder, and hit ctrl-c.  That should create a copy of your 'real' calendar in this backup folder.\n\nThen, go back to the Advanced Find window.\na) If you used outlook's hollidays feature, sort first by location (I assume you are in the US), under United States, wipe them ALL out (you can always add these later with a few clicks)\nb) now sort by dates.  Wipe out all the old stuff you couldn't care less about\nc) now sort by Subject.\nd) time to work down-arrow, delete, down-arrow, delete, down-arrow, delete, etc...\n\ngood luck
633256
I think your problem is more basic than this.\n\nYou define a variable named dt and are stuffing a date into it.  This is all well and good.\n\nBut in the next line, you're doing an SQL select.  In this line, dt is the name of a field in table [current$].  The two lines aren't related even though they have the same name.  \n\nIf you want the query to pull back data where the value in field dt is equal to the date 10/5/03, then you have to add a where clause to the SQL query:\n\n"Select dt as CloseDate from [current$] where dt=" & strDate\n\nNot sure which database you are using to select from, so the syntax may be slightly off, but you get the picture.  The thing here is that the SQL query is all text...even the date part.  The only exception to this is if you are running a stored procedure and some of the inputs are declared to be datetime data types.
502425
You have the classic problem with the FoxPro event loop. FoxPro is now an event-driven language. When you are testing in the development environment Fox is continually waiting for your input. When you have an exe running outside the environment Fox runs through the main program, loads your forms but then continues to the end of the main program and halts. You need to add two commands to your project.\n\nAdd READ EVENTS as soon as you launch your form. This will tell Fox to go into its event-processing loop. \n\nAdd CLEAR EVENTS the the Quit button. This tells Fox to stop waiting for events and to contine execution from the line after READ EVENTS. If you forget the CLEAR EVENTS then you'll get a "Cannot quit Visual FoxPro" message and have to crash out of it with the Task Manager.\n\n\n\nI've got a longer explanation with screen shots at http://www.alvechurchdata.co.uk/fox101exe.htm
275090
It depends on the type of database.\n\nFor Access, assuming your dates are stored in a Date/Time field:\nSELECT * FROM table WHERE start_time > #1/2/2004 21:43:24# AND stop_time < #1/3/2004 6:43:24#\nOptionally, without time:\nSELECT * FROM table WHERE start_time > #1/2/2004# AND stop_time < #1/3/2004#\n\nMake sure you order your dates by the proper locale; e.g, mmddyyyy or ddmmyyyy.\n\nNote also that I did not use stop or start as column names. Those are reserved words in just about every relational database.\n\nFor Transact-SQL (MSSQL), assuming your columns are  DateTime, send your dates as strings:\nSELECT * FROM table WHERE start_time > '1/2/2004 21:43:24' AND stop_time < '1/3/2004 6:43:24'\n\nFor MySQL, assuming you are using an int column to store a Unix timestamp, just send Unix timestamps:\n\nSELECT * FROM table WHERE start_time > '1433232923' AND stop_time < '1433732923'
147561
You could use the split function to get each part of the date and re format it as you want :\n\nie\n\n<?php\n// Delimiters may be slash, dot, or hyphen\n$date = "04/30/1973";\nlist($month, $day, $year) = split('[/.-]', $date);\necho "Month: $month; Day: $day; Year: $year<br />&#92;n";\n?>\n\nSource --> http://uk2.php.net/split\n\nAs for connecting to the database using odbc etc , I have never done that , Just search on google, there are plenty of examples.\n\nGoogle is your friend :)
891022
error in your first line:\n\nchange\n\n$currentmonth = $_GET['$d']; \n\nby\n\n$currentmonth = $_GET['d'];
25507
There's a magic formula using the DateDiff function: =DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now(), "mmdd") < Format( [Birthdate], "mmdd") )\n\nBasically, you need to paste this into the first ("Field") row of any column in a query.  This assumes that the query already includes a table with a field called Birthdate.
224148
<span id="tP"> </span>\n\n<script type="text/javascript">\n// Clock Script Generated By Maxx Blade's Clock v2.0d\n// http://www.maxxblade.co.uk/clock\nfunction tS(){ x=new Date(tN().getUTCFullYear(),tN().getUTCMonth(),tN().getUTCDate(),tN().getUTCHours(),tN().getUTCMinutes(),tN().getUTCSeconds()); x.setTime(x.getTime()+19800000); return x; } \nfunction tN(){ return new Date(); } \nfunction lZ(x){ return (x>9)?x:'0'+x; } \nfunction tH(x){ if(x==0){ x=12; } return (x>12)?x-=12:x; } \nfunction y2(x){ x=(x<500)?x+1900:x; return String(x).substring(2,4) } \nfunction dT(){ window.status=''+eval(oT)+''; document.title=''+eval(oT)+''; document.getElementById('tP').innerHTML=eval(oT); setTimeout('dT()',1000); } \nfunction aP(x){ return (x>11)?'pm':'am'; } \nvar dN=new Array('Sun','Mon','Tue','Wed','Thu','Fri','Sat'),mN=new Array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),oT="dN[tS().getDay()]+' '+tS().getDate()+' '+mN[tS().getMonth()]+' '+y2(tS().getYear())+' '+':'+':'+' '+tH(tS().getHours())+':'+lZ(tS().getMinutes())+':'+lZ(tS().getSeconds())+' '+aP(tS().getHours())";\nif(!document.all){ window.onload=dT; }else{ dT(); }\n</script>