How to Convert Inf Values to Missing Values in Date or DateTime (POSIXct) Columns

When you have Inf values in date or datetime (POSIXct) columns and want to replace them with missing values:

  • Select the target column, and from the column header menu, choose “Missing Value (NA) Processing” → “Replace … with Missing Value (NA)”

  • Click the Custom tab in the conditions field and enter:
  is.infinite(column_name)

  • Click the Execute button

This will replace all Inf values with missing values (NA).