I want get the Queue items which is added from date start to current datetime
what will be the exact date time i have to provide in get Queue item property.
Thanks in Advance
I want get the Queue items which is added from date start to current datetime
what will be the exact date time i have to provide in get Queue item property.
Thanks in Advance
You can just use DateTime.Now in “To” field and the start date in “From” field.
Or
Just populate “From” field so the activity get the queue items from start date until time of execution
One point: the Get Queue Items activity return the maximum of 100 items by execution. If you need more, you need to do extra step
May I know what is the start date?
Also it has limit of 100 so you might need to use a loop to get all the items
To field is not needed as it is today only
Here is an example of how to create loop to get all items
Cheers
Hello @ManjunathReddy
Assign activity:
startDate = New DateTime(2023, 01, 01)
Set your start date
Assign activity:
endDate = DateTime.Now
Current date and time
Assign activity:
dateFilter = $“DateCreated >= ‘{startDate.ToString(“yyyy-MM-ddTHH:mm:ss”)}’ AND DateCreated <= ‘{endDate.ToString(“yyyy-MM-ddTHH:mm:ss”)}’”
Get Queue Items activity:
SpecificData = dateFilter
Thanks & Cheers!!!
In the Properties of Get Queue Items
From: DateTime.Parse(“2021-01-01”) ’ Or use your specific start date
To: DateTime.Now
If you want to include the entire day in your end date (up to 23:59:59 of the current day), you can do something like this:
To: New DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59)
In which field we should use this datefilter?
dateFilter = $“DateCreated >= ‘{startDate.ToString(“yyyy-MM-ddTHH:mm:ss”)}’ AND DateCreated <= ‘{endDate.ToString(“yyyy-MM-ddTHH:mm:ss”)}’”