'11/29/2011 is not a valid date' On FlowField Drilldown

Jonathan2708
Jonathan2708 Member Posts: 552
edited 2011-11-30 in NAV Three Tier
Hi,

I have created a FlowField in a custom table to count the number of Sales Header records for set criteria. One of the criteria is where a date field in my custom table equals the 'Shipment Date' in the Sales Header table. The FlowField counts the records fine, and in Classic I can drilldown on the FlowField to the 'Sales List' form to view the records. However in RTC when I try to drilldown I get the error '11/29/2011 is not a valid date'. Obviously it's trying to apply the filter on the Sales Header table using USA date format, when all my regional settings are for UK.

Can anybody shed any light on this?

Thanks,

Jonathan

Comments

Categories