Hi Vincent,
This is another thing to do with dates. Hopefully, you'll be able to reproduce this one as I think it would be much easier to reproduce, especially because it's displaying military time with the year, month and day separated by "-".
This does come up with an error when the DR report is run, which I'm not sure why, but it does display the two dates in the incorrect format, which is why I'm using "FormatDate" to try to rectify it.
The regional settings on my computer are set to "dd/MM/yyyy" and the time is set to 24-hour, although this doesn't show the time of course. I'm also starting the WebApp using localhost and the WebApp displays dates perfectly.
The first line is in the DF19.1 WebApp report code.
The lines starting with "let" through to "return (s)" is in a DR function in a .DR file, while the last line is what is actually printed in the DR report.
Of course, I'm trying to display "From 01/08/2017 to 31/08/2017" on the report, but the code in the DR function has something (yet to figured out) not quite correct.
Code:
//DF19.1 WebApp:
Set psFilterFunction sReportId to ('From ' + "FormatDate(" + sTripTmpStartDates[0] + ",drCustomDateMask,'dd/MM/yyyy')" + ' to ' + "FormatDate(" + sTripTmpStartDates[1] + ",drCustomDateMask,'dd/MM/yyyy')")
//DR7.0 function:
let s = Replace({&Filter Function}, '"', "")
let s = Replace(s, '"', "")
let s = Replace(s, '"', "")
let s = Replace(s, '"', "")
let s = Replace(s, '"', "")
let s = Replace(s, '"', "")
let s = Replace(s, '"', "")
let s = Replace(s, '"', "")
return (s)
//Print result within the actual report:
From FormatDate(2017-08-01,drCustomDateMask,'dd/MM/yyyy') to FormatDate(2017-08-31,drCustomDateMask,'dd/MM/yyyy')