Problem with using sysdate in infopath

Richie Rich — Thu, 16 Sep 2010 15:10:56 GMT

Hi,

I have just started using Microsoft Infopath last week, I have a small problem regarding only pulling entries from the SQL Server that are todays date and after.

Scenario is that I have a main data source which my forms submits data into the database, then I have a secondary data source that is a SQL statement that just displays the Test Machine name, Booked Date and Timeslot.

select "BookingDate","TimeSlot","TestMachine" from "dbo"."TestRoomBooking" as "TestRoomBooking" order by "BookingDate"

This then pulls a list of all the bookings from the database.

All I need is to be able to add a clause onto that statement or somewhere else saying that I only want to show dates that are today's date and onwards. therefore not displaying old dates that are redundant.

Regards

Rich

Newbie Questions

Problem with using sysdate in infopath