How to auto fill DATE with an increment only in seconds by 1

Hi all,

New one to uipath… Actually I have achieved it in excel but too tedious to get data for 10 year.
If the above statement is confusing… s I have a requirement say,
Below is the image I need like that…
date range is from 01/01/2019 to 31/12/2030.

I have tried using
Convent. Todatetime(01/01/2019 00:00:00).addseconds(01)…

Bjt.o help…

can u share ur workflow?

@Newuser123 kindly try if this works for you
Sequence.xaml (8.6 KB)

1 Like

See if this one helps. Maybe a variation from the solution already provided.
Sequence.xaml (6.8 KB)

1 Like

Use this below code,
Cdate(DateTimeVariable).AddSeconds(1)

It works so cool but it takes it from 12:00:00pm I need it from 12:00:00 am…

Can I add

@jcvsalinasi tried this it works but it is giving me from 12:00:00 pm… So iaddedd in while condition as 00:00:00 next to 31/12/2030

@jcvsalinasnot working as I told

@jcvsalinas not working as I told… Please discard my previous requezt

If you have a look at the seq i have shared the time value and periods
Also i took enddate+1 to get until the last second of 31st

1 Like

@nadim.warsi thanku so much…

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.