Converting 7 digits number to date format

[former_member661280]

Hi there,

If i have this number 1190130 (representing 20190130), how can I changed it to "01/30/2019".

Thanks.

[ayman_salem · Accepted solution]

First remove the first character from the number "1190319" (using Substr), then use "ToDate" to convert it to date, and finally format the date with "FormatDate" to the desired format.

...

(Suppose N is the variable that contains the number to be converted.)

N: ="1190130"

NN: =Substr([N];2;Length([N])-1)

n_Date: =FormatDate(ToDate([NN]; "yyMMdd"); "MM/dd/yyyy")

[former_member661280 · Accepted solution]

Works perfect. Thanks a lot!