How to use interface tool for below mention Query ?

[Jaganmohan]

 Normally we use Time stamp as a filter  to extract the price information from Database - Could you please help me how to use interface tool for below mentioned timestamp query.

For example : Time stamp range as mentioned below

where Invoice date >= '20210829000000' and

invoice date < '20210830000000'

How can we use interface tool for above query - user need to enter start date and end date while running the tool.

Thanks in Advance.

[jrgo]

@Jaganmohan 

You can use the expression below to convert a date field to the format you need. Below is an example if you're using the Date interface tool, but could also just be used in a normal formula tool.

DATETIMEFORMAT([#1], '%Y%m%d000000')