Using Case with DATEDIFF for Aging Report

• Ysa

  Mr or Mrs. 500

  Points: 553

  More actions

  November 24, 2022 at 11:36 am

  #4117544

  I need help to create a Aging report, I am not retrieving the correct amounts.

  I am wondering if I need add debit and credit first and then the dateiff

  

• Eirikur Eiriksson

  SSC Guru

  Points: 182915

  More actions

  November 24, 2022 at 12:43 pm

  #4117573

  Can you please post the DDL (create table) script, sample data as an insert statement and the desired output from the sample data?

  😎