Convert Integer to Date

Hi everyone,

 

I want to convert a number "19990101" to date format. What is the best way to do this?

 

PS. I've already done this code to get the date, but I want to know what is the best way.

local!year: left(19990101, 4),
local!month: mid(19990101, 5, 2),
local!day: right(19990101, 2),
date(local!year, local!month, local!day)

 

Thanks in advance

  Discussion posts and replies are publicly visible