Empty Field DateTime value null

[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.

[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

[lfcapacio]

Thank you for your attention.

I'm waiting.

[Alex K.]

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.

[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

[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.

[lfcapacio]

Hello,

In version 2017.1.8 the problem continues.

I wait.

Thank you.

[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.

[lfcapacio]

Hello,

Attached files example of the problem.

Thank you.

[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.