Microsoft Dynamics CRM (Archived)

FetchXml date

(0) Share

Report

Posted on by Haider Ali

I want to know what is the format(UTC or LocalTime) of DateTime when fetching Data using FetchXml.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Shahbaaz Ansari 6,211 on at

Like (0)

Report

Hi haider,

It depen upon the time format that you have set in personal option,

but you can modify it accordingly after getting the result of fetch xml.

Best Regards.,

Shahbaaz

Was this reply helpful? Yes No
Suggested answer

Tadhg 75 on at

Like (0)

Report

Hi Haider,

It is in LocalTime format.

If you are wondering about searching across time zones, see the below link:

community.dynamics.com/.../mscrm-fetchxml-filter-based-on-time-and-time-zone

Hope this helps!

Was this reply helpful? Yes No
Suggested answer

Radu Chiribelea 6,667 on at

Like (1)

Report

Hi Haider,

Please see: technet.microsoft.com/.../dn946904.aspx

Hope this helps

Radu

Was this reply helpful? Yes No
Haider Ali 15 on at

Like (0)

Report

Thanks for the Reply Tadhg

Was this reply helpful? Yes No
Haider Ali 15 on at

Like (0)

Report

Thanks Shahbaaz

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Haider,

Seems the date format in dynamics CRM is MM/dd/YYYY HH:MM . I am not sure you may can change this settings. You can try to login CRM Async server , Application Server , with CRM app pool user credentials and go to the region settings and changes the date format.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Haider ,

The date format inside CRM you can change by system settings->Administrator->System Settings -->Formats and this will be applied in UI for all date time field.

Hope this helps.

Was this reply helpful? Yes No