How to set the date format and get particular data

If I mention the date then corresponding data should be sum and display in the cell
how to specify the date

@anjani_priya
would you please give some input and output

Book1.xlsx (407.5 KB)
from ly sheet the date should be taken as 9/30/2022
and the sum of amount should be written in input sheet by the date and subgrouping reference
in aop sheet and cy sheet the date should be 9/30/2023

Can you please provide the date format:

dateStr = “10/25/2023”
newDateStr = DateTime.ParseExact(dateStr, “dd/MM/yyyy”, CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)

date = DateTime.ParseExact(“25/10/2023”, “dd/MM/yyyy”, CultureInfo.InvariantCulture)
newDateStr = date.ToString(“MM/dd/yyyy”)

Assign activity:
dateStr = “25/10/2023”
date = DateTime.ParseExact(dateStr, “dd/MM/yyyy”, CultureInfo.InvariantCulture)
newDateStr = date.ToString(“MM/dd/yyyy”)

It is in the above file

Then Try the above solution

that is not my requirement

your requirement is not clear can you please explain

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