DateTime format issue

(0) Share

Report

Posted on by Venkateshwar_Indian

105

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

All responses (3)

Answers (1)

Verified answer

AlexDen 90 on at

Like (0)

Report

RE: DateTime format issue

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

Like (0)

Report

RE: DateTime format issue

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
AlexDen 90 on at

Like (0)

Report

RE: DateTime format issue

Hello.

Look at the function ConvertToUtcDateTime in 358cu.

You can use the same approach.