Show null for certain date

building reports desktopintelligence
1

I have DESKI report and certain date column is getting inserted as a default date 1/1/753 12:01:00 AM. I would like to show as null whever the value is above. This i tried using with alerters, but i applied with decode statement in universe. Some reason, even though i decoded in universe, still showing the value as 1/1/1753 12;01:00 AM. Please advice how to make it null.

pkommidi (BOB member since 2006-03-10)

2

Replace your date object with a variable like

= if( FormatDate( [Date variable]; "dd/MM/yyyy hh:mm:ss AM" ) = "1/1/1753 12;01:00 AM"; ; [Date variable])

Mick

[Moderator Edit: Added code formatting - Jansi]

mikca :australia: (BOB member since 2005-12-16)

3

As this is posted in Desk-I sub forum, please use Mick’s code with Desk-I syntax.

Jansi :india: (BOB member since 2008-05-12)