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 CRM (Archived) / FetchXml date
Microsoft Dynamics CRM (Archived)

FetchXml date

(0) ShareShare
ReportReport
Posted on by Haider Ali 15

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

*This post is locked for comments

  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at
    RE: FetchXml date

    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.

  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at
    RE: FetchXml date

    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.

  • Haider Ali Profile Picture
    Haider Ali 15 on at
    RE: FetchXml date

    Thanks Shahbaaz

  • Haider Ali Profile Picture
    Haider Ali 15 on at
    RE: FetchXml date

    Thanks for the Reply Tadhg

  • Suggested answer
    Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at
    RE: FetchXml date

    Hi Haider,

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

    Hope this helps

    Radu

  • Suggested answer
    Tadhg Profile Picture
    Tadhg 75 on at
    RE: FetchXml date

    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!

  • Suggested answer
    Shahbaaz Ansari Profile Picture
    Shahbaaz Ansari 6,211 on at
    RE: FetchXml date

    Hi haider,

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

    1348.time.PNG

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

    Best Regards.,

    Shahbaaz

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
dkrishna Profile Picture

dkrishna 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans