Calendar/date issue - please help!

[alexis]

Hi

I have attached a QVW that has a simplified view of my problem.

The QVW has a data file "Welfare payments" and a "Calendar" which I generate to offer rich calendar-type functionality

The 2 tables are linked by a field called "PaymentDate"

For some reason, none of the selections from a Calendar field take me to the relevant records. This is driving me insane. Any suggestions.

Regards and thanks in advance

Alexis

[rwunderlich]

That's correct. The decimal part is the time. I put WFormattedPaymentDate in a list box and changed the number format to timestamp (or fixed number of decimal places).

-Rob

[alexis]

Thanx Rob - that was very helpful!