Use arcade to convert a number to a date

MaryroseKulick

Hello!

I'm working on displaying fields in a list in a dashboard, and I'm struggling to accomplish this goal:

I have a number field representing a date formatted as: 7012021

I need it to read as : July 01 2021 or 7/01/2021

Any tips are appreciated! I am new to arcade, so I'm having trouble figuring out the right function to use. The replace function almost worked, but it's not quite what I need.

Thank you!

 

 

 

jcarlson

Building off this, you can use left, right, and count together to get the various date parts out regardless of whether the leading zero is present or not.

By returning a true Date object, you can then modify that to output to any format you like, so if you prefer the long date style of "July" instead of "7", you can do that.

var dateNum = Text(7012021)

var y = right(dateNum, 4)
var d = left(right(dateNum, 6), 2)
var m = left(dateNum, 8 - count(dateNum)) - 1

// month is returned as the number - 1, as Date function takes month as a 0-indexed value, i.e., January = 0

var dt = Date(y, m, d)

return Text(dt, 'MMMM DD Y')