How to compare glide date and glide date time fields

[sk59]

Hi,

I have two fields glide date(Start Date,End Date) and glide date time(Process Date) fields.

If the fields are having the dates as below am trying to fetch the records which has the condition Process Date > Start Date and Process Date < End Date

Ex:

Start Date - 1:10:2017       End Date - 31:10:2017

Process Date - 31:10:2017 11:59:59

I am able to get all the records which has the date between 1:10:2017 and 31:10:2017 except the last day of the month (Ex: 31:10:2017 10:00:00)

Please suggest the possible ways to get those records as well.

Thanks in Advance.

[AbdulAzeez]

then you can convert all the 3 date fields later you can pass your query condition