How to dynamically pick the date from the below mentioned format

Help Automation Ops
,
8

Hi @anjani_priya

First get the date

inputDateString = New DateTime(Now.Year, Now.Month, 1).AddDays(-1).AddDays(
If(New DateTime(Now.Year, Now.Month, 1).AddDays(-1).DayOfWeek = DayOfWeek.Saturday, -1, 
If(New DateTime(Now.Year, Now.Month, 1).AddDays(-1).DayOfWeek = DayOfWeek.Sunday, -2, 0))).ToString("dd MMMM yyyy")

Use select item acticity indicate it on the year dropdown for the year and pass the expression
inputDateString.Split(" "c)(2)

For month
use while loop

  • Use get text and indicate it on the month
  • If it is equal to inputDateString.Split(" "c)(1) use break activity to break from the loop
  • Else click on the next arrow mark

For date
date = inputDateString.Split(" "c)(0)
Use click activity
In the dynamic selector add the variable date

Hope this helps!

1 Like