Skip to main content

Last time TIER form was modified

  1. Last updated
  2. Save as PDF

Overview

Find out the last time you made a change to a TIER form. 

Details

Below is an SQL view that will list each TIER form and the date it was last modified. The SQL view shows the OP__ID, OP__TIERNAME and the OP__LastModifiedDate from the T4W_Forms table. This is helpful when trying to determine if the changed TIER form is being used or when was the last time a particular TIER form had been changed. The SQL view also converts the OP__LastModifiedDate into the more readable Julian date.

/* vwTIERFormLastModified */
create VIEW vwTIERFormLastModified

AS

SELECT op__id,op__tiername,
CONVERT(datetime,CONVERT(varchar(2),month) + '/' + CONVERT(varchar(2),day) + '/' + CONVERT(varchar(4),year)) AS LastModifiedDate

FROM (SELECT op__id,op__tiername,op__lastmodified ,Year ,Month
,(op__lastmodified - (yearcode*33554432 + Month*2097152))/65536 AS Day

FROM (SELECT op__id,op__tiername,op__lastmodified ,1980+YearCode AS Year
  ,YearCode,(op__lastmodified-(YearCode*33554432))/2097152 AS Month

  FROM (SELECT op__id, op__tiername ,op__lastmodified
       ,op__lastmodified/33554432 AS YearCode  

FROM t4w_forms  
)y 

  )m

)d

tier_squlastmodified.png

* The SQL view was compliments of Jim von Stein at SOASTC in Oregon.