web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / DateTime format issue
Microsoft Dynamics NAV (Archived)

DateTime format issue

(0) ShareShare
ReportReport
Posted on by Venkateshwar_Indian 107

Hello All,

Please help me out,

I am working on integration project, where I have to integrate nav with some third party application, that application completely runs with UTC time , so while calling any api if there is any datetime field in my request, till now I have converted my datetime field to utc time by writting this one line code FORMAT(DATETIME,0,9), 

my question is in response I'm receiving datatime value in utc time how to convert this time to my local time which is in cst timezone

can I make use of config file to overcome this but currently my nav application is integrated with couple of others application , changing config file should not effect them

please advice

thanks

*This post is locked for comments

I have the same question (0)
  • AlexDen Profile Picture
    AlexDen 90 on at

    Hello.

    Look at the function ConvertToUtcDateTime in 358cu.

    You can use the same approach.

  • Venkateshwar_Indian Profile Picture
    Venkateshwar_Indian 107 on at

    Hello AlexDen,

    Thanks for your reply can you tell one more thing. how to convert

    text = '2018-07-06T02:47:31Z' to nav datatime field

  • Verified answer
    AlexDen Profile Picture
    AlexDen 90 on at

    EVALUATE(DateTime,'2018-07-06T02:47:31Z',9);

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans