How to get the difference between a Existing date Column and Today or Current date

[Dhiraj Kr_ Gupta]

There is a column Last Working Date in the form mmddyyyy, I want to create condition based on the difference between the last working date and today's date whenever a last working date added. Current Time stamp in SQL is giving error

Suppose

Last working date | Difference | Status

3/2/2023                    355.             needed 

4/5/2023                     325.           Completed 

1/23/24                       27.             Completed

Here difference got between each value in the last working date and if difference is greater than 335 then Needed and if not then Completed.

Kindly help

[Stiltsoft support]

Hi @Dhiraj Kr_ Gupta ,

Please check the following Community questions regarding your case:

https://community.atlassian.com/t5/Confluence-questions/Conditional-Formatting-for-Confluence-tables/qaq-p/1568284

https://community.atlassian.com/t5/Confluence-questions/Table-transformer-conditional-logic-to-color-code-rows/qaq-p/2605277

Seems that they exactly are what you are looking for.