Write a datetimes from Last Date to Today date

Help StudioX
,
1

Dear Team,

I have excel as below,
I would like to write the date time from last date in the sheet till the current date time for the 4 fixed times.
Current Sheet:
image

Expected Output:

ECOO Autoreport Status 2024.xlsx (12.1 KB)

Thanks,
Amol

2

@Amol_Golhar

Can you briefly explain

3

Dear Team,

As i have dates in the sheet for in the 4 fixed times as shown in sheet for 4:10, 10:10, 16:10, 22:10 for each day.

I would like to take last datetime from the sheet and write the dates in the below same way till the current datetime.

Thanks,
Amol

4

Hi @Amol_Golhar

Could you be more specific and explain. Please share the expected output.

Regards

5

Dear Team,

I have datetimes as below from 11 feb to 13 feb:

11-Feb-2024 04:10
11-Feb-2024 10:10
11-Feb-2024 16:10
11-Feb-2024 22:10
12-Feb-2024 04:10
12-Feb-2024 10:10
12-Feb-2024 16:10
12-Feb-2024 22:10
13-Feb-2024 04:10
13-Feb-2024 10:10
13-Feb-2024 16:10 - Last Date from the sheet

I want to write the datetime from 13 feb to 15 feb As below:

13-Feb-2024 22:10
14-Feb-2024 04:10
14-Feb-2024 10:10
14-Feb-2024 16:10
14-Feb-2024 22:10
15-Feb-2024 04:10
15-Feb-2024 10:10 - Till the current datetime.

Thnaks,
Amol

6

Hi @Amol_Golhar

Check out the below zip file
Excel Forum.zip (170.0 KB)

Sheet1 is the output sheet

image
image848×592 7.94 KB

Regards

7

@Amol_Golhar

inputDataTable=(From row In inputDataTable.AsEnumerable()
                     Let emailTimeVRL = If(Not row.IsNull("EmailTime VRL"), DateTime.ParseExact(row.Field(Of String)("EmailTime VRL"), "d-MMM-yyyy HH:mm", CultureInfo.InvariantCulture), DateTime.MinValue)
                     Where emailTimeVRL <> DateTime.MinValue
                     Order By emailTimeVRL Descending
                     Select row).CopyToDataTable()

Output:
image

8

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