Page 1 of 2
Empty Field DateTime value null
Posted: Tue Jun 06, 2017 2:58 pm
by lfcapacio
Hello,
When I have a field of type DateTime and the field value is null when selected the Text Format field to Custom and select any option or even a new Format Mask for example dd/MM/yy HH:mm:ss is displayed content Format Mask and not white as it should be.
How do I get the value out blank when null?
Thank you.
Re: Empty Field DateTime value null
Posted: Wed Jun 07, 2017 11:18 pm
by Edward
Hi Ifcapacio,
Please change the text format to 'General' and use the following expression in the text component:
Code: Select all
{IIF(Orders.ShippedDate==null,"",Orders.ShippedDate.ToString("dd MMMM yyyy HH:mm:ss"))}
The Orders.ShippedDate is a nullable DateTime column.
We will inform you in this topic when this bug is fixed.
Thank you,
Edward
Re: Empty Field DateTime value null
Posted: Thu Jun 08, 2017 2:56 pm
by lfcapacio
Thank you for your attention.
I'm waiting.
Re: Empty Field DateTime value null
Posted: Mon Jun 12, 2017 6:36 pm
by Alex K.
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
Re: Empty Field DateTime value null
Posted: Tue Jul 04, 2017 12:58 pm
by lfcapacio
Hello !
Any predictions for solving this issue?
I realize that the problem only occurs when the custom option is selected, the pre-determined works correctly.
Still awaiting.
Thank you
Re: Empty Field DateTime value null
Posted: Thu Jul 06, 2017 6:33 am
by Vladimir
Hello,
The error is fixed, it does not occur when testing version 2017.1.8. The Custom Date and Time format works correctly for data columns and variables.
The new release 2017.1.8 is now on internal testing and will soon be available.
Thank you.
Re: Empty Field DateTime value null
Posted: Fri Jul 07, 2017 12:53 pm
by lfcapacio
Hello,
In version 2017.1.8 the problem continues.
I wait.
Thank you.
Re: Empty Field DateTime value null
Posted: Sat Jul 08, 2017 8:14 am
by Alex K.
Hello,
We couldn't reproduce this issue on our samples with our test data.
Please send us a simple report with test data which reproduces the issue for analysis.
Thank you.
Re: Empty Field DateTime value null
Posted: Mon Jul 10, 2017 2:06 pm
by lfcapacio
Hello,
Attached files example of the problem.
Thank you.
Re: Empty Field DateTime value null
Posted: Mon Jul 10, 2017 3:13 pm
by HighAley
Hello, Luis.
We have reproduced the issue.
We are working on it and will let you know when we get any result.
Thank you.