Getting Date Only from JSON

Stimulsoft BI Designer discussion
Post Reply
tbagby
Posts: 24
Joined: Mon Apr 22, 2024 1:42 pm

Getting Date Only from JSON

Post 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.
Attachments
DesignerTable.png
DesignerTable.png (38.18 KiB) Viewed 16607 times
JSONDateFromPostMan.png
JSONDateFromPostMan.png (8.6 KiB) Viewed 16607 times
Lech Kulikowski
Posts: 7332
Joined: Tue Mar 20, 2018 5:34 am

Re: Getting Date Only from JSON

Post by Lech Kulikowski »

Hello,

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

Thank you.
tbagby
Posts: 24
Joined: Mon Apr 22, 2024 1:42 pm

Re: Getting Date Only from JSON

Post by tbagby »

Appreciate the help Lech - that worked.
Lech Kulikowski
Posts: 7332
Joined: Tue Mar 20, 2018 5:34 am

Re: Getting Date Only from JSON

Post by Lech Kulikowski »

Hello,

You are welcome.
Post Reply