Can we extract sharepoint data for specific days?

Hi All,

My requirement is, in sharepoint Created Date column is there in dd/mm/yyyy hh:mm AM/PM format.How to extract data for specific days from the current date.
For example, If number of days is 60 then the data should be extracted as created date column - 60.
How to do this? Please help.

Hi @Srinu755

Use Assign with Date Variable as CreatedDate avraible
CreatedDate=row(“CreatedDate”).ToString

use Cdate(createdDate).toString(“dd/mm/yyyy hh:mm:ss tt”)

in if condition use

createdDate<=60 or createddate>=60
then do the manipulations

Thanks
Ashwin S

Hi Ashwin,

Thank you for your response. However, am looking for while extracting data itself, it has to check and extract the data. Am not sure, whether it has 100 records or 200 records while extracting the data. So can’t keep max rows can extract as 100 or 200 and then do the manipulations after extraction.