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
Hi @Dhiraj Kr_ Gupta ,
Please check the following Community questions regarding your case:
Seems that they exactly are what you are looking for.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.