How to fetch queue data base on timestamp?

[Sanket_Shinde1 (Sanket Shinde)]

Hi Team
I have added queue with timestamp reference

now I want to get those queue items How can I get base on date time ?

see the picture

I want queue items from 03/07/2024 20:27:49

[rlgandu (Rajyalakshmi Gandu)]

@Sanket_Shinde1

[Sanket_Shinde1 (Sanket Shinde)]

I have tried but not comming

[Sanket_Shinde1 (Sanket Shinde)]

Also I have not specify any parameter in from to field

[rlgandu (Rajyalakshmi Gandu)]

@Sanket_Shinde1

Is there any condition to get the specific range datetime queue items.In reference you used Get asset value what input that it contains…?

[Parvathy (PS Parvathy)]

Hi @Sanket_Shinde1

Try this way:
DateTime.ParseExact("03/07/2024 20:27:49", "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)

Regards

[Sanket_Shinde1 (Sanket Shinde)]

Within that variable I have store DateTime value

[Sanket_Shinde1 (Sanket Shinde)]

I want to keep DateTime dynamic

[Parvathy (PS Parvathy)]

Hi @Sanket_Shinde1

It should present date and time right?

Regards

[Parvathy (PS Parvathy)]

Hi @Sanket_Shinde1

DateTime.ParseExact(Now.ToString("MM/dd/yyyy HH:mm:ss"), "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)

Regards

[rlgandu (Rajyalakshmi Gandu)]

@Sanket_Shinde1

Sequence12.zip (2.5 KB)
Input:

[Siva_krishna_Thumma]

Hey Hi,

Check this approach.

• First Identify queue items that are available with you date range. For that take “Get Queue Items” and filter with only date will get all the available processing date queue items

• Filter the date List_Dates.Where(function(x) DateTime.ParseExact(str_YourQueueRefDateAndTime, str_YourQueueRefDateFormate, System.Globalization.CultureInfo.InvariantCulture) > dt_InputDateandTime).ToArray
• For each filtered date

1. If queueitem is nothing continue.
2. If queueitem not nothing break

Hope this would helps you.

[Sanket_Shinde1 (Sanket Shinde)]

Yes it has has the date and time some time it will have yesterday datetime as well

[Parvathy (PS Parvathy)]

Hi @Sanket_Shinde1

You want to get the queue items of the present date and time. Is there any other requirement.

Regards