Small and medium business | Business Central, N...

Converting DateTime to UNIX Timestamp in AL/Business Central - Strange behavior with Decimal to String conversion

(0) Share

Report

Posted on by rtechc

Greetings Community -

I found an online blog (don't remember the URL) which helped me get the function below to convert DateTime format to UNIX Format.

The output of the below function is accurate, however, when I get the Decimal as a return value of the function and try to convert it to text, the additional spaces show up between the digits, strangely enough

After trying DELSTR(String,'='), the spaces don't go away. I am probably missing something, can anyone please assist?

ajkauffmann

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

DAnny3211 11,417 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi

try this

DELCHR(ResourceUpdAPIPArams,'=',' ')

DAniele

Was this reply helpful? Yes No
rtechc 20 on at

Like (0)

Report
Copy link

Link copied!

Hi Daniel - Thanks for the suggestion. I tried both these formats of DELCHR, but it does not seem to work, same output. Moreover, when I try to find the position/occurrence of a blank character in the string using STRPOS, it gives me a 0 (no blank substrings exist)

I then tried converting my string output into ASCII, and there are ASCII Blank spaces in between. I am really confused as to what is happening

Do you know what is happening?

String Pasted from the Debugger: 1 674 610 728 407

Was this reply helpful? Yes No
Suggested answer

ajkauffmann 117 on at

Like (0)

Report
Copy link

Link copied!

The Format command includes all signs by default. In your case the thousand delimiter is probably a space.

The best option is to use an extra parameter to indicate how the decimal should be formatted. The standard XML format will work here:

Format(UnixDecimal, 0, 9);

Then you don't need to remove any character afterward.

Was this reply helpful? Yes No