Share
ReportHi,
I have created a view in sql and linked it to Smartlist using Smartlist Designer.
My issue is when I use the Smarlist search function to search for a date using the lookup calendar e.g. 1st of Feb 2018, the smartlist result is for the 2nd of Jan 2018.
This is a date formatting issue ( I am in Australia) and I tried the following in the view but it still did not resolve the issue:
Convert(date,field,103) - does not work.
Format (field ,d, en-au) - works in the back end but not in gp.
Varchar will also not work in gp as I need to search by date.
Any idea how to fix that issue?
Thanks a lot,
Nicolas
*This post is locked for comments
All responses (
Answers (
3