Skip to Content (Press Enter)
UserImage.jpg
Primal Lobo
731Views
5Comments
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
Copy Link
2022-02-07 08-52-30
Pranav Pandey
Solution

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

4
0
24 Jan 2020
Copy Link
UserImage.jpg
Primal Lobo

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
Copy Link
2024-09-03 10-16-38
Prasath P

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 2022
Copy Link
UserImage.jpg
Yanick Trindade

Thank you so much!

0
0
10 Oct 2024
Copy Link
UserImage.jpg
Cesar Boucas

Here a simple approach that does not require aditional "if" statement: set the "Null Value" property of the text input field to #1900-01-01# (using the sharp characters #, instead of quotation marks).  

0
0
03 Mar 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.