looking for date functions with sql toolkit

[sebi]

I'm using sql toolkit with CVI6.0 for MDB database (access).
I need to select all data with the same week, but there is no function for week asking. How can i do? Thanks

[DanielMcchane]

Sir,
Where do you have the dates located? Is it a column in your database? You may want to use the DBGetParamAttribute function with the ATTR_DB_PARAM_VALUE to compare the values of the parameter and then do a sort according to the date values. More information on this function is provided in the manual, which you can download at http://digital.ni.com/manuals.nsf/websearch/D3DF4019471D3A9386256B3C006CDC78?OpenDocument&node=132100_US
Please let me know if I have misunderstood your question. Thanks, and have a great day.

Daniel McChane
Application Engineer
National Instruments

[davidx]

Well if you datas has the attribute ... for example "Week" in the table "Team" the SQL statement would be like that:

"SELECT * FROM Team WHERE Week=37"

for further infos,so look in the example library DATABASE from CVI.

Hope it helps..