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.