Clappy2000
Technical User
I have a Date Prompt in a freehand SQL query in a Web Rich Client report.
I've used the following code to achieve that:
WHERE e.data_hora_inicial >= @prompt('Start of Period','D',,Mono,Free,Persistent,,User:0)
The underlying data in PostgreSQL and data_hora_inicial is a Timestamp column.
However when ever I run the report the prompt is only returning the Date and not the time. I've proventhat by including the @prompt as one of the columns returned and it only returns the date and a time of 00:00:00 when formatted to show date and time.
If I swap out the @prompt for a hard-coded Date and Time the query works as I would expect.
Am I doing something wrong?
Any advice appreciated.
Thanks
I've used the following code to achieve that:
WHERE e.data_hora_inicial >= @prompt('Start of Period','D',,Mono,Free,Persistent,,User:0)
The underlying data in PostgreSQL and data_hora_inicial is a Timestamp column.
However when ever I run the report the prompt is only returning the Date and not the time. I've proventhat by including the @prompt as one of the columns returned and it only returns the date and a time of 00:00:00 when formatted to show date and time.
If I swap out the @prompt for a hard-coded Date and Time the query works as I would expect.
Am I doing something wrong?
Any advice appreciated.
Thanks