Help with computed column

I have a table that has a date column. I want to add a computed bit column that indicates which record has the latest date, i.e., the "active" record.

How can I do this?
LVL 1
HLRosenbergerAsked:
Who is Participating?
 
FarWestConnect With a Mentor Commented:
if you have duplicate rows with different dates (example client info multiple records) in the table and you want computed column to test if this record is the last one, I think this is not possible,
using views  is better to  achieve this,
0
 
HLRosenbergerAuthor Commented:
ok thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.