Log in to AnswerLog in to Follow
UserImage.jpg
Primal Lobo
311Views
3Comments
Solved
display blank instead of "1900-01-01" 
Question

Hi


I want to display the blank  instead of  "1900-01-01"  in the table if the suitable date is not there can anyone help me in this?


Thank you

0
0
24 Jan 2020

Hi Primal Lobo,

Basically this indicates that no date was provided and it the null date value in outsystems. While displaying you can use if condition to check for null value and display blank. Please see the sample below

SyntaxEditor Code Snippet

if(Tags.List.Current.UpdatedOn = NullDate(),"",Tags.List.Current.UpdatedOn)

Hope this will help.

Thanks

3
0
24 Jan 2020

pranav pandey wrote:

Hi Primal Lobo,

Basically this indicates that no date was provided and it the null date value in outsystems. While displaying you can use if condition to check for null value and display blank. Please see the sample below

SyntaxEditor Code Snippet

if(Tags.List.Current.UpdatedOn = NullDate(),"",Tags.List.Current.UpdatedOn)

Hope this will help.

Thanks

yes worked , 

Thank you


0
0
24 Jan 2020

Replying to Primal Lobo's comment on 24 Jan 2020 09:21:01

how to do data conversion it's not working from my side.

0
0
02 Jun
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.