Write Range Activity Fails To Update Cells In The Expected Format

News Knowledge Base
1

How to use Write Range Activity to write date in this format "yyyy-mm-dd" ?

Root Cause: Date format not set correctly.


Resolution: Check whether the target cell is set to the expected format. If not follow the below steps:

  1. Open the Excel file
  2. Navigate to Format Cells>Number>Date
  3. Select the format "yyyy-mm-dd" > Click OK