Manual: v5 - page 209, v6 - pages 73-74
On page 209, the manual states that regardless of the 'show time' setting a time argument is always required with a date. If a date is not supplied, Portfolio will always append the time 12:00:00 to the date string. However, if you do a Find on a Date/Time (D/T) field and supply no time argument, after the Find executes the dialog date string box shows the date plus 00:00:00 (e.g. 02/11/1999 00:00:00). It appears the search is carried out using date+00:00:00, rather than date+12:00:00.
Note this also means that trying to match a D/T field on date alone is effectively impossible unless you know the Time part of the target D/T field.
It also appears from experiment (Win 2k SP3, UK localised, client v6.03) that the minimum entry acceptable for a DT comparison is month and year (either mm yy or mmm yy) as long with the arguments are separated by a space, forward slash, hyphen or comma. The dialog will accept "8 98" and show "01/08/1998 00:00:00" indicating that if no day is supplied, day #1 of the month is presumed; indeed, in this context a dot (period), comma, single space, hyphen or forward slash all work as a separator character (though backslash will not, lest you wonder).
If the month argument is supplied in text form (e.g. 'Sep') either m/d or d/m order can be used - the resultant string in the dialog box will be shown according to user local settings (e.g. as a UK user I get dd/mm/yyyy hh:mm:ss). It is not clear what a user with a non-English language OS will get, i.e. whether the client will still accept the local language's month strings instead of the English ones.
Question: Can I do a find based only on Date and not Date/Time? [FAQ00192.htm]
Last Update:- 31 May 2006
Site and articles © Mark Anderson 2001-2007 - Visit my home page