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

Dhiraj Kr_ Gupta
Contributor
February 20, 2024

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

1 answer

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 20, 2024

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events