Empty Field DateTime value null
Empty Field DateTime value null
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.
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.
- Attachments
-
- print1.png (78.72 KiB) Viewed 8281 times
-
- print2.png (36.38 KiB) Viewed 8281 times
Re: Empty Field DateTime value null
Hi Ifcapacio,
Please change the text format to 'General' and use the following expression in the text component:
The Orders.ShippedDate is a nullable DateTime column.
We will inform you in this topic when this bug is fixed.
Thank you,
Edward
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"))}
We will inform you in this topic when this bug is fixed.
Thank you,
Edward
Re: Empty Field DateTime value null
Thank you for your attention.
I'm waiting.
I'm waiting.
Re: Empty Field DateTime value null
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
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
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
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
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.
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
Hello,
In version 2017.1.8 the problem continues.
I wait.
Thank you.
In version 2017.1.8 the problem continues.
I wait.
Thank you.
- Attachments
-
- screen1.png (106.08 KiB) Viewed 8192 times
-
- screen2.png (26.64 KiB) Viewed 8192 times
-
- screen3.png (13.24 KiB) Viewed 8192 times
Re: Empty Field DateTime value null
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.
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
Hello,
Attached files example of the problem.
Thank you.
Attached files example of the problem.
Thank you.
- Attachments
-
- Desktop.zip
- (4.61 KiB) Downloaded 412 times
Re: Empty Field DateTime value null
Hello, Luis.
We have reproduced the issue.
We are working on it and will let you know when we get any result.
Thank you.
We have reproduced the issue.
We are working on it and will let you know when we get any result.
Thank you.