LAST PLAYED date REFORMAT?

[Freddy Barker]

Hi coders and developers:

I've been looking for a way to display the LAST PLAYED date as 'UNKNOWN' if unknown/blank and 'TODAY' if Last Played was on todays date?

At the moment I'm using this:-
$Date(<Last Played>,dd/mm/yy) - CREDIT to Redwing...

No luck with my attempts, so any help most appreciated - Thanks very much!

Best Regards: Fred  

[Bee-liever]

At the moment I'm using this:-
$Date(<Last Played>,dd/mm/yy) - CREDIT to Redwing

For the unknown part, you could try:
$IsNull(<Last Played>,"UNKNOWN",$Date(<Last Played>,dd/mm/yy))
That won't work as <Last Played> never returns a null value.
If <Last Played> has no value it already returns Unknown
So if you want it in capitals:
$If(<Last Played>="Unknown","UNKNOWN",$Date(<Last Played>,dd/mm/yyy))

[redwing]

I don't think it's possible to output today's date with virtual tags.

[Freddy Barker]

At the moment I'm using this:-
$Date(<Last Played>,dd/mm/yy) - CREDIT to Redwing

So if you want it in capitals:
$If(<Last Played>="Unknown","UNKNOWN",$Date(<Last Played>,dd/mm/yyy))

That worked great, and as usual, thanks so much for assistance, feedback, tips and fixes.
The UNKNOWN now looks a lot better than "BLANK"  
Best Regards: Fred

[Freddy Barker]

I don't think it's possible to output today's date with virtual tags.

Thanks so much for your reply/response! My OCD will have to cope without the TODAY part!!
Best Regards: Fred