Timestamp field = Filter?

[Lyonel]

Hi,

Any idea how I can apply a date time range selector on a "timestamp" database field?

Thanks!

[Guest]

Hi @Lyonel

It depends on where you want the date range selector to appear. 
This can be performed in the reporting function using a combination of the "User Prompted Value" and "Between Date/Time Selector" on the Filter Tab. 

 

This then presents you with a selection box when you preview, or run the report:

 

Is this was you are looking for?

Kind Regards

Bob

[Lyonel]

Hi @Bob Dickinson, I know about the date time range selector and it works like a charm... if the field type in the database is a date time. But with timestamp it is a bit different. For example, in the table sys_notification_history:

 

[Guest]

Hi @Lyonel

Ah I see - sorry for the misunderstanding. I don't think we have got anything specific to accommodate this in terms of the prompt options currently. I will check internally and come back to you. 

Kind Regards

Bob