Trying to avoid multiple date entry for task schedule project .. i am stuck here and need help

let table = base.getTable('Tasks');

let query = await table.selectRecordsAsync()
 // get the cell  values of the table
 
 
 // looping through records
for (let record of query.records ) {

   //start date
  let startDate = record.getCellValue('Start Date')
    
   //end date
   let endDate = record.getCellValueAsString('End Date')

       let available = record.getCellValue ('Next Workday')

  if (startDate  == endDate){

  }
    
 
    
}

I’ve edited your post for readability. When you enter a code block into a forum post, please precede it with a separate line of three backticks and follow it with a separate line of three backticks to make it easier to read.

You can also use the “preformatted text” tool in the editor (</>) to add backticks around text.

See this post to find the backtick on your keyboard.
Note: Backticks (`) are not single quotes (’).

1 Like

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