Page 1 of 1

Getting Date Only from JSON

Posted: Fri Aug 23, 2024 9:18 pm
by tbagby
I am trying to work with two date fields (started and ended) which are datetime fields in my JSON data source. When I use them in Stimulsoft Designer, all I get is the date and they are set as type "datetime." I've tried setting the data type in data dictionary as "string" also but no change. How can I get the full date and time value into my dashboard? Attached is a snip from Postman on the same data source and what I'm seeing in Stimulsoft.

Re: Getting Date Only from JSON

Posted: Mon Aug 26, 2024 8:58 pm
by Lech Kulikowski
Hello,

Try to use the following expression:
DateTime(datasourceName.ColumnName)

Thank you.

Re: Getting Date Only from JSON

Posted: Thu Aug 29, 2024 2:13 pm
by tbagby
Appreciate the help Lech - that worked.

Re: Getting Date Only from JSON

Posted: Thu Aug 29, 2024 4:57 pm
by Lech Kulikowski
Hello,

You are welcome.