topic Data Expression Date Formatting Dashboard Arcade in Developers Questions

Data Expression Date Formatting Dashboard Arcade

BugPie — Thu, 31 Aug 2023 14:32:52 GMT

I have a Data Expression in a Dashboard that is used to create a table. Works great, was built by someone else.

I have one change I need to make but have been unable to get the syntax correct. I'm trying to get the table to return the date as a date only, no time.

The bottom half of the code is attached here. I left out the variables and portal item stuff. How do I get Date only in the return?

Re: Data Expression Date Formatting Dashboard Arcade

jcarlson — Thu, 31 Aug 2023 14:46:35 GMT

That part of the code isn't the issue. A date field is always going to include time, regardless of whether a time is specified when the data is created. To change how it displays, you'll need to use Advanced Formatting, then use something like Text($datapoint['Due_Date'], 'MMM DD, YYYY') to get an output like Aug 31, 2023.

Re: Data Expression Date Formatting Dashboard Arcade

BugPie — Thu, 31 Aug 2023 15:19:46 GMT

Oh for goodness sake, I'm so disappointed in myself!

OK, this makes so much more sense on why I could figure out how to use the code block to format the return. It's formatting!! That did the trick and I am eternally grateful for your help... again.

Re: Data Expression Date Formatting Dashboard Arcade

lannguyentl — Fri, 28 Feb 2025 01:21:42 GMT

Hi there, I'm quite interested in your conversation with other regarding the Text() function in Advanced formatting for List. Could you please share how you play with the return? I cannot find the way. Thank you very much!