Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Use Time in Advanced Find
Microsoft Dynamics CRM (Archived)

Use Time in Advanced Find

(0) ShareShare
ReportReport
Posted on by Abbod Hamwi 585

Hi

any idea how can i use Time in advanced find 

for Example this is my records 

Work Order Number Work Order Type Time Window Start Time Window End
WO-48038 Regular 12/12/2016 0:00 12/12/2016 2:00
WO-47993 Regular 10/12/2016 0:00 10/12/2016 1:00
WO-47988 Regular 10/12/2016 0:00 10/12/2016 1:00
WO-47983 Regular 10/12/2016 5:00 10/12/2016 17:00
WO-47978 Regular 10/12/2016 5:00 10/12/2016 17:00
WO-47966 Regular 10/12/2016 0:00 10/12/2016 1:00
WO-47877 Regular 08/12/2016 22:00 10/12/2016 1:00

i need only to get the workorders that Time Window in 10/12/2016 5:00

So any idea

Thanks And Regards

*This post is locked for comments

  • Abbod Hamwi Profile Picture
    Abbod Hamwi 585 on at
    RE: Use Time in Advanced Find

    Hi

    I just want to ask you as you have too much experience in CRM , Is it possible to change the view fetchxml in run time via JavaScript

    i was thinking that in the main entity window i will add button to the Ribbon will show html page that i will take the date and time and then i will re build the fetchxml and set it for the view (Regardless selected view).

    so as your knowledge is this going to work

  • Abbod Hamwi Profile Picture
    Abbod Hamwi 585 on at
    RE: Use Time in Advanced Find

    Thanks For Replay

    I will solve it by making WPF Application For This purpose only

  • ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: Use Time in Advanced Find

    Another way of course would be to export to excel and do the comparisons there!

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: Use Time in Advanced Find

    As far as I know the only way you can do this is export the fetchxml from your advanced find and then run it using XrmToolbox (or any other way of running fetchxml) and add the hour part into the date query.

  • Abbod Hamwi Profile Picture
    Abbod Hamwi 585 on at
    RE: Use Time in Advanced Find

    Thanks For replay

    The Problem the management request for something easier from Next X Hour - etc.

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,074 on at
    RE: Use Time in Advanced Find

    Hi,

    You can try filtering the records using the last x minutes or next x minutes filter criteria in advanced find. Please go through the following links.

    www.powerobjects.com/.../crm-2011-truths-about-datetime

    gonzaloruizcrm.blogspot.in/.../date-and-time-operators-in-crm-explained.html

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans