hi guys i am puting this query in my querybuilder in the table adapter but i need to make the query only return
the transaction done today!! i dont know the syntax to get the cuurent date today. this query should work in the tableadapter query configuration wizard!!!
SELECT Trans_ID, Trans_Cash, Trans_Deposit, Trans_Mtc, Trans_Alfa, Trans_Desc, Trans_Delete_Flg, Trans_Date, Trans_User_Name, Trans_Admin_Flg, Trans_Msg_Cost FROM Transactions WHERE (Trans_Admin_Flg = FALSE) AND (Trans_Date >= .....?????
thanks for the help