Getting Date Only from JSON
Getting Date Only from JSON
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.
- Attachments
-
- DesignerTable.png (38.18 KiB) Viewed 16605 times
-
- JSONDateFromPostMan.png (8.6 KiB) Viewed 16605 times
-
- Posts: 7332
- Joined: Tue Mar 20, 2018 5:34 am
Re: Getting Date Only from JSON
Hello,
Try to use the following expression:
DateTime(datasourceName.ColumnName)
Thank you.
Try to use the following expression:
DateTime(datasourceName.ColumnName)
Thank you.
Re: Getting Date Only from JSON
Appreciate the help Lech - that worked.
-
- Posts: 7332
- Joined: Tue Mar 20, 2018 5:34 am
Re: Getting Date Only from JSON
Hello,
You are welcome.
You are welcome.