Customer experience | Sales, Customer Insights,...

Get Records with exact date

(0) Share

Report

Posted on by NK Bhairi

244

Hi,

We have an Custom Entity with Enddate field which is of date and time.

We want to get all records that have enddate exactly in next 30th day. We want to check this condition in a workflow.

Tried using the Next X days= 30 , but this will give all the records that have enddate in next 30 days, not the ones that have the enddate exactly 30 days from today.

Any OOB ways to achieve this, by using the dynamic filters in workflow?

I have the same question (0)

All responses (2)

Answers (0)

Charan Raju C R 7 Moderator on at

Like (0)

Report

RE: Get Records with exact date

Hi,

I assume you're trying to retrieve the records using fetch XML or query expression from custom workflow. In order to get the records having End Date exactly on the day 30 days from today, first you need to find out what is the exact date after 30 days from today by adding 30 days to today's date.

DateTime desiredEndDate = DateTime.Now.ToLocalTime().AddDays(30);

Convert this date to string with format "yyyy-MM-dd".

string desiredEndDateStr = desiredEndDate.ToString("yyyy-MM-dd");

Place this desired end date string to value part of the fetch XML or query expression condition.

<condition attribute='new_enddate' operator='on' value='" + desiredEndDateStr + "' />

OR

QueryExpression query = new QueryExpression("new_customentity")

{

Criteria = { Conditions = { new ConditionExpression("new_enddate", ConditionOperator.On, desiredEndDateStr) } }

};

Was this reply helpful? Yes No
Suggested answer

Menna El Sayed Galal on at

Like (0)

Report

RE: Get Records with exact date

Hello ,

you can try using this by checking the enddate is before or after as your business logic require and use the exact days inside the condition as below

please let me know if this help achieve what you need to achieve.

Was this reply helpful? Yes No