Notifications
Announcements
No record found.
Hi, How can I convert DateTime format to UnixTimestamp:BigInteger in business central ?
thanks
calc the difference between the datetime and 1/1/1970 in seconds. thats then the unix timestamp.
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.
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 :)
Maybe this can help you:
andreilungu.com/.../
And also this maybe:
github.com/.../6663
procedure GetUtcDateTime(sourceDateTime: DateTime) UtcTime: BigInteger;
var
TempTime: Text;
begin
TempTime := Format(sourceDateTime, 0, 9);
TempTime := DelChr(TempTime, '=', '-:.TZ');
Evaluate(UtcTime, TempTime);
end;
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,238
YUN ZHU 773 Super User 2025 Season 2
Sumit Singh 630