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

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.