Oct 23, 2008 · Hi Cosmid, sorry, I was possibly a little unclear. In order to specify a date using that methodology, you have to specify the check as '01JAN1988'd for instance, as opposed to …

Dec 11, 2008 · 25 Cambridge 30/10/08 I then have a completeley seperate list of approval dates which is stored in an excel spreadsheet e.g. 20/10/08 25/10/08 01/11/08 I would like the submission date …

Apr 10, 2003 · The only thing I can suggest is to create two identical workbooks -- one with 1904 dates and the other without -- and compare them byte by byte. If you discover where the setting is stored, …

Jul 10, 2003 · Can anyone tell me the best way to compare 2 dates rather than using the DateDiff function. Using date1>date2 gives inconsistant results, although I would like to use this type of …

Apr 25, 2007 · you an convert the dates into the format brigmar has shown you and compare the dates as strings, or use the Time::Local module, which comes with perl, to convert dates to epoch time and …

Apr 13, 2004 · You need to either compare the System date with the last row of the Ordered By query, BEFORE you add the new record, OR you need a sequnce number column in the table which will …

Jun 9, 2012 · Hi Group, Why does Gantt Chart View vs. Tracking Gantt views have radically different views? Also, why does one need individual headers & footers between to the 2 different style views? …

Apr 5, 2012 · I can copy cells with tasks and dates from Excel into Project2010 with no problems. Yet, when I copy the tasks and dates from Project back to Excel, the Date cells are not recognized as …

Jun 26, 2012 · You can use Excel's SaveAs method to create a CSV file, which VFP can open directly. You can also write VFP code to loop through the Excel data and copy it into a cursor, but that will be …

Oct 5, 2002 · For each record I need to compare date 1 to date 2, if not more than 7 months then compare date 2 to date 3, and so on. If any 2 dates are more than 7 months, the record must be …