Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Dhiraj Kr_ Gupta 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


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
AUG Leaders

Atlassian Community Events