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