Dates not returning null

Question

After our upgrade to 10.1.5 I have noticed a change. 
 Before, in version 9.2, whenever I pulled in the LastVisitedDate from a user profile, if the user has never visited after their account creation (null value in SQL), then it also returned null. 
 Now running the same scripts, then it returns 1/1/0001 12:00:00 AM . 
 Is this by design, or is it a bug?

Ben Tiedt · Accepted Answer

I recommend Robert Nash 's second work-around. I've also logged this as a bug: 
 106309

Verint | Telligent Community · Answer

' #106309 LastVisitedDate returning DateTime.MinValue instead of null ' has been completed for 6/2018 - June Service Pack .

Robert Nash · Answer

ah apologies I miss understood, sounds like something changed in the code. 
 $user.LastVisitedDate > '0001-1-1 00:00:00.000' won't work as you are doing a less than comparison on a string. Have you tried 
 $user.LastVisitedDate != '0001-1-1 00:00:00.000' 
 or 
 $user.LastVisitedDate > $core_v2_utility.ParseDate("1", "1","1")

Dates not returning null

Top Replies