The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.
Hello,
So I have a table in my DB which stores data along with start and end date and time(datatype is datetime). Now, I have defined two inputs to my service which is a query to select certain data where start time and end time are inputs. the baseType is datetime. When i enter the values, im getting the result as no data, but I have given the exact date and time as in the db table.
Solved! Go to Solution.
Hi,
the format was wrong actually. I used the format function to get it right.
Something that has bitten me a few times is that when you feed datetime inputs using widgets on a mashup, it uses the local time zone of your browser and then passes in UTC time to the service. Perhaps this is what's up?
Hi,
the format was wrong actually. I used the format function to get it right.