I’m not sure if this contributes to this thread, but I’ve just stumbled upon this problem - still learning about it.
I created a document via LS agent and poplulated a date field with “03/18/2007”. When I display that field in a column using @Text(PayCycleEndDate;“D0S0”), it displays as 3/17/2007.
In the document properties (infobox), the value of the field appears to be 03/18/2007 12:00 AM.
When I try to search the database looking for 03/18/2007, I do not get any hits, but a search for 03/17/2007 DOES return hits.
Based on what I’ve seen, the @Text formula isn’t working correctly, and neither is the Search function.