Query only last 15 days in SQL

J

JC

Successfully created an Infopath form with drop down control to query SQL
database. Only want to see the last 15 days data, (currently showing all
dates).
Not sure how to configure and what conditional formatting strings if any
should be created?
Please help.
 
S

S.Y.M. Wong-A-Ton

How about creating a view on your SQL database and adding the filtering to
the statement for the view? SQL Server has date functions you can use. Then
bind the drop-down to the view.
 
Top