Selecting a date in a BAQ

(system) #1

We are on 9.05.700C

I have created an SQL view of some data that returns a date using this format: Convert(date, ShipHead.ShipDate) as ShipDate.

The date is displayed in the External BAQ as date format 99/99/99. In the BAQ I can enter a fixed criterion to select just one day, but in the BAQ Report options the date selection is ignored.

Can anyone suggest what the issue might be?

Neil Buckman

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies -

P Please consider our shared environment before printing this communication.