Dates not returning null

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?

Top Replies

Ben Tiedt over 6 years ago in reply to Robert Nash +3 verified

I recommend Robert Nash 's second work-around. I've also logged this as a bug: TE-8932: LastVisitedDate returning DateTime.MinValue instead of null Completed for 10.1.8.10498 , 10.2.2.3444
Robert Nash over 6 years ago in reply to Erik P. Ernst +1 verified

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…
Verint | Telligent Community over 5 years ago +1 verified

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

Parents

0 Erik P. Ernst over 6 years ago

Maybe it was like this in 10.0 and 10.2, but it was not working like this in 9.2.

It's a bit annoying, as I had a widget checking on the field being null. Right now I'm having a bit of trouble checking this date.

I'm trying with:

#if ($user.LastVisitedDate == false) || ($user.LastVisitedDate > '0001-1-1 00:00:00.000')

Also tried with '1/1/0001 12:00:00 AM'. But it doesn't work. Any suggestions regarding a workaround?

And still wondering why it would set it to the birthday of Jesus. I'm using the code together with FormatAgoDate = telling the user last visited more than 2017 years ago!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Erik P. Ernst over 6 years ago

Maybe it was like this in 10.0 and 10.2, but it was not working like this in 9.2.

It's a bit annoying, as I had a widget checking on the field being null. Right now I'm having a bit of trouble checking this date.

I'm trying with:

#if ($user.LastVisitedDate == false) || ($user.LastVisitedDate > '0001-1-1 00:00:00.000')

Also tried with '1/1/0001 12:00:00 AM'. But it doesn't work. Any suggestions regarding a workaround?

And still wondering why it would set it to the birthday of Jesus. I'm using the code together with FormatAgoDate = telling the user last visited more than 2017 years ago!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Wilfried Rijsemus (3sides) over 6 years ago in reply to Erik P. Ernst

There must be a 'good reason for it' but I am not aware of it. I've vented in the past more than once that those kinda changes should be checked with us. Most of us here have deep knowledge and also know the impact of those changes.

In this case I have no answer to your particlar question. I'll ask my dev today
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel