Ahmed_ABOELEANI

4 - Data Explorer

since

‎Nov 29, 2022

User Statistics

1 Posts
0 Solutions
4 Kudos given
0 Kudos received

User Activity

Posts
Replies

"Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date."

Apr 17, 2021

Hi Community, i’m extracting the date from the below string 27909270100235 = 1979-SEP-27 using a formula below DATETIME_FORMAT(RIGHT(LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),4),2)&"/"&RIGHT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)&"/"&IF(...

Kudos given to

User

Count