How To Subtract a number of days from a date column

[Bernardus_Bambang_Herjuno]

Hello everyone, so I have a table in Coda doc which contains a column with date format. I want to create a next column which contain the dates from the previous column but subtracted 45 days (45 days before the date in the first column). I can do this easily in Excel, but somehow I can’t do this in Coda. Can anyone help me?

[Jean_Pierre_Traets]

Dear @Bernardus_Bambang_Herjuno

Welcome to the Coda Maker Community

I assume that it’s this what you are looking for:

[Bernardus_Bambang_Herjuno]

I tried that. but I got this error:

My formula looks like this:
= Table 1.Deadline PKWT - 45

[Bernardus_Bambang_Herjuno]

Problem Solved. I directly referenced the column not using the Table 1 Name. Thank you!

[Paul_Danyliuk]

@Bernardus_Bambang_Herjuno

= Table 1.Deadline PKWT - 45

Your formula should look like

thisRow.[Deadline PKWT] - 45

or even better, more explicitly

thisRow.[Deadline PKWT] - Days(45)

because the former way relies on the fact that Coda calculates dates as numbers (Excel style), which might change eventually.

You can omit the thisRow but it’ll still mean thisRow.
When you use TableName.Column this means read the whole column — i.e. a list of values, one value for every row.

[Jean_Pierre_Traets]

Thanks for the additional explanation @Paul_Danyliuk , valuable input for everyone willing to learn the Coda logic!