Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 March 2023

Top 3 Topics with Most Views

RPA Assignment Problem - exporting/importing files from Access DB made by @Jackson_Hew with 43 views.

How to type in data into application text field without using the application? made by @yadish.s with 42 views.

How do I save the latest file from a folder, move it to another folder and rename the file? made by @Shannon_Quek with 38 views.

Top 3 Topics with Most Replies

Unable to read same excel file twice in the same process made by @hari.vishalmudra2 with 16 replies.

How do I save the latest file from a folder, move it to another folder and rename the file? made by @Shannon_Quek with 14 replies.

SELECTOR WILDCARD DOUBT made by @BHUVAN with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@Yoichi made 26 posts!

@arjunshenoy made 14 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

How do I save the latest file from a folder, move it to another folder and rename the file?

Hey @Shannon_Quek , 1.You can use this Directory.GetFiles(“C:\Users\Jithesh.R\Downloads\Whatsapp”,“*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) 2.You can use Move File Activity to move the file from one location to another [image] You can use Rename FIle Activity to rename a file [image] Regards,

This post made by @pradeep_ch received 2 likes!

Announcing the Winners of AI Awards 2023

Thank you so much @loredana_ifrim @Vibhor.Shrivastava

This post made by @imran.loon received 2 likes!

Announcing the Winners of AI Awards 2023

Thank You @Vibhor.Shrivastava @loredana_ifrim Congratulations to all winners​:clap:t3:

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

How do I save the latest file from a folder, move it to another folder and rename the file?

Hey @Shannon_Quek , 1.You can use this Directory.GetFiles(“C:\Users\Jithesh.R\Downloads\Whatsapp”,“*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) 2.You can use Move File Activity to move the file from one location to another [image] You can use Rename FIle Activity to rename a file [image] Regards,

This solution provided by @Yoichi received 2 likes!

Month+String+Year(1 year ahead) calendar window

Hi, How about the following expression? Now.ToString("MMM")+" FY "+Now.AddYears(1).ToString("yy") [image] OR The following will also work. Now.AddYears(1).ToString("MMM \F\Y yy") Regards,

This solution provided by @Yoichi received 1 likes!

Set Dynamic Delay in Delay Activity

Hi, Can you try to use TimeSpan.FromSecond method etc, as the following? [image] TimeSpan.FromSeconds(delaySec) note : delaySec is Double type variable Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.