Update only if file was created/modified today?

[god_prophet]

We're reading a file from SFTP. 

This file is called file.csv every day. We only need to load its data if it is a new file, e.g. created or modified today. 

Is it possible to check the metada of a file within Campaign? 

[_Manoj_Kumar_]

Hello @god_prophet 

You will have to use a javascript code before uploading the file to check if the file date is before today or not.

The code to get the modified date of a file is this:

var PATH=getOption("SFTP_UploadFolder");
var FOLDER_PATH=PATH+"/FILE_NAME.csv";

var myFile = new File(FOLDER_PATH);
 
logInfo(myFile.lastModified); // this will return the modified date

[god_prophet]

@_Manoj_Kumar_  actually the last line gives error: 

BAS-010034 Unable to change date of file 'path_of_file/file.csv.gz'.