Auto compute in date format issue

daw7
New Member

Situation:

  • I have my first column named [Date A] in date format. This is where I input my data.
  • I got another column named [Date B] in date format, with auto compute formula of โ€œ[Date A] + 30โ€
  • My intention is to show that column [Date B] is 1 month (or 30 days) ahead of column [Date A]
  • column [Date A] has no initial value since this is where I want to input my data
  • column [Date B] has no initial value also since it already contains an auto compute formula

Issue

  • Even if column [Date A] has no data input yet, column [Date B] will show a value of โ€œ01/31/1970โ€
  • I tried putting an initial value on column [Date B] of " " which basically what I want is to show a blank value initially, but my app displayed an error message "Value โ€˜NaN/NaN/0NaNโ€™ in field โ€˜Date Bโ€™ cannot be converted to type โ€˜Dateโ€™.

Please help. Thank you!

Solved Solved
0 2 640
1 ACCEPTED SOLUTION

You can try app formula for [Date B]:

IFS(ISNOTBLANK([Date A]), [Date A]+30)

View solution in original post

2 REPLIES 2

You can try app formula for [Date B]:

IFS(ISNOTBLANK([Date A]), [Date A]+30)

Well this works great! Thank you @Heru

Maybe the issue was on the calendarโ€™s default value after all.

Top Labels in this Space