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

All responses (3)

Answers (0)

Suggested answer

ajkauffmann 117 on at

Like (0)

Report

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

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.
rtechc 20 on at

Like (0)

Report

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

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
Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

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

hi

try this

DELCHR(ResourceUpdAPIPArams,'=',' ')

DAniele