Hi, I am trying to use a button to make my selection, I only want my button to return data for only the things that has happen today using this date format: 2012/02/29 10:06:00 AM,
this is the expresion I was trying to use but its not working
Does the Date() function above return as you expected, and that the format is the same that the field Test_Date has? Apart from that, where are you using that expression? Is that an action? I should have asked before.
Yes the Date function retuns the corect values on theTest_Date field, but now the problem is that it doesnt return anything if I use the filter "Daily". and I am using the Exprestion on the expresion tab of the table chart that Im using to disply the results, I added the action "Set Variable" on the button that passes through the variable Report type to Table chart.
I'm afraid I'm missing something. You original question was about a button to make a selection in a field. Did you try to create a button, and in its properties set a new Action, Selection, Select in Field, Test_Date and
=Date(Today(), 'YYYY/MM/DD hh:mm:ss TT')
as the Search String?
If this is not what you are after, would you mind to upload some dummy example so we can check further?
That’s exactly what I am trying to do, The problem only came up when changing the date formats, because when I am using the YYYY/MM/DD date format it doesn’t give me a problem. Please see the attached dummy model I am using!
Note that the function above returns a complete timestamp, and you may not have records with that timestamp. So I'd create a button with an action Select in Field Test_Date1, and the following as Search String:
.png "Miguel_Angel_Baeyens"){kind=avatar}
