Retrieve specific datetime based on user inputted information

0
Hi all,  In our app we monitor how much fluid someone has through the day, the user will click to add a new record which asks for the date, time and the volume of fluid the individual had. Once they click save the microflow needs to look at the date then retrieve from the database the record for that date and add the volume to that date’s record.  The daily record is simply just Date and total volume.  I’m having trouble setting up the microflow to retrieve the required record, the dates are stored. As the dates in the record are stored as, for example, 23/10/2019 00:00:00, but the date of the record the user has inputted is 23/10/2019 10:37:00. So I can’t just retrieve that data from the datebase as it won’t find it.  Is there anyway I can create a variable to set the user inputted date to the same day but change the time to 00:00:00 and then retrieve using that.  I may be going about this the wrong way, so please let me know of any better ways of doing this 
asked
0 answers