Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • Reply To: Calculating Age

    DECLARE @DOB DATETIME, @CurrDT DATETIME, @YY INT, @mm INT, @DD INT

    SET @CurrDT = GETDATE()

    SET @DOB = CONVERT(DATETIME,@Filter1,101)--'1984-11-12'

    SET @YY = YEAR(@CurrDT) - YEAR(@DOB)

    SET @mm = MONTH(@CurrDT) - MONTH(@DOB)

    SET @DD = DAY(@CurrDT)...

    October 1, 2024 at 4:43 pm

    #4464261

  • Reply To: Calculating Age

    DECLARE @DOB DATETIME, @CurrDT DATETIME, @YY INT, @mm INT, @DD INT

    SET @CurrDT = GETDATE()

    SET @DOB = '1984-11-12'

    SET @YY = YEAR(@CurrDT) - YEAR(@DOB)

    SET @mm = MONTH(@CurrDT) - MONTH(@DOB)

    SET @DD = DAY(@CurrDT)...

    October 1, 2024 at 4:32 pm

    #4464258

Viewing 2 posts - 1 through 3 (of 3 total)