How to get dates in between two dates of different month?

2 Likes

hello @SOURAV_KUMAR_DAS
Find the attached workflow.GetDates_Between_Two_dates.xaml (6.0 KB)

2 Likes

Hi Sir,

I got your solution now I want to write those dates into excel.

I am getting error on foreach loop

@SOURAV_KUMAR_DAS
Add that Build Data Table Above the While Loop
Add Add Data Row Inside the While Loop.

1 Like

Hi Sir,

The data row of for each should be added in the while loop Sir…?

@SOURAV_KUMAR_DAS
yes it should be Added in While Loop…because we are not adding those dates in any collection.if we doesn’t add in While Loop It will take only Last date.
For your understanding i Have made Changes in workflow so take a look it.GetDates_Between_Two_dates.xaml (7.9 KB)

1 Like

Hi Sir,

Thank You Sir for your solution.
Keep it on Sir…

1 Like

Hi jitendra_123 Sir,
If I want to exclude Saturday and Sunday from those days, what should be done.

@SOURAV_KUMAR_DAS
Use If Condition and use following code in it.
TempDate.DayOfWeek.ToString<>"Saturday" Or TempDate.DayOfWeek.ToString <>"Sunday"
Then in the Then part move that Add Data Row.

4 Likes

Hi jitendra_123 Sir,

This is the area know Sir…

@SOURAV_KUMAR_DAS
Yes, Is It working for you?

1 Like

Hi Sir,

For confirmation I have shared you the image…

Hi jitendra_123 Sir,

No Sir it is not working Sir, it’s getting Saturday as well as Sunday dates in the excel sheet.

@SOURAV_KUMAR_DAS
Find attached workflow.GetDates_Between_Two_dates.xaml (8.6 KB)

5 Likes

Hi jitendra_123 Sir,

Thanks for your help Sir.

2 Likes

Hi jitendra_123 Sir,

I have another question

How to extract searched text from PDF file of online document?

if there’s any solution please let me know Sir.

@SOURAV_KUMAR_DAS
Can you provide any sample PDF File?

1 Like

Hi jitendra_123 Sir,

Yes Sir.

This is the link Sir.

http://clists.nic.in/ddir/PDFCauselists/madras/2019/Oct/01331102019.pdf

Hi jitendra_123 Sir,

If my searched text is “TCA/796/2019” in the current pdf link

http://clists.nic.in/ddir/PDFCauselists/madras/2019/Oct/01331102019.pdf

then it should extract these message and write it in any document.

so can you explain in sample workflow.

@SOURAV_KUMAR_DAS
Download that PDF and Use Get OCR Text.
then using regex Extract only those text that you want to extract.

1 Like