Conveting DateTime format to TimeStamp format in business central

(0) Share

Report

Posted on by faran1

115

Hi, How can I convert DateTime format to UnixTimestamp:BigInteger in business central ?

thanks

I have the same question (0)

All responses (6)

Answers (0)

Smart App Business ... 10 on at

Like (0)

Report

RE: Conveting DateTime format to TimeStamp format in business central

procedure GetUtcDateTime(sourceDateTime: DateTime) UtcTime: BigInteger;

var

TempTime: Text;

begin

TempTime := Format(sourceDateTime, 0, 9);

TempTime := DelChr(TempTime, '=', '-:.TZ');

Evaluate(UtcTime, TempTime);

end;

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,041 Moderator on at

Like (0)

Report

RE: Conveting DateTime format to TimeStamp format in business central

And also this maybe:

github.com/.../6663

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,041 Moderator on at

Like (0)

Report

RE: Conveting DateTime format to TimeStamp format in business central

Maybe this can help you:

andreilungu.com/.../

Was this reply helpful? Yes No
MohitMalik8085 100 on at

Like (0)

Report

RE: Conveting DateTime format to TimeStamp format in business central

HI Faran,

I hope you get your solution some how. could you please help me for the same thing like, I want to get the timestamp for the current datetime. it would be very much appriciate if you can give me some idea for the same how I can achieve the same.

Thanks in Advance :)

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,233 Super User 2025 Season 2 on at

Like (0)

Report

RE: Conveting DateTime format to TimeStamp format in business central

Are you using OnPrem or on Saas? because for OnPrem you have functions in Type Helper or DateTime offset codeunit but they are DotNet and works only in OnPrem.

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

RE: Conveting DateTime format to TimeStamp format in business central

calc the difference between the datetime and 1/1/1970 in seconds. thats then the unix timestamp.

Was this reply helpful? Yes No