Calendar Control is not working as expected when we choose the Data type as 'DateTime'.

  • 28 August 2015
  • 0 replies
  • 9 views

Badge +11


 

Symptoms


When a date is selected using the Calendar Control with Data Type set to 'DateTime' and then passed to the data label it is being displayed as the selected date minus one day.
 

Diagnoses


Data label returns “incorrect” value due to time zone conversion and formatting issues, but correct value stored in the database nonetheless. This is known issue and though data label displays incorrect date the data in the database is saved correctly.

Following workaround can be used in this scenario instead of using the calendar control value directly in a rule:

1. Drag a textbox control onto the layout canvas and set Visible = False
2. Create the following expression on the textbox: Format Date and Time (Calendar Control, yyyy/MM/dd)
3. Configure the rule to use the textbox control to display the Formatted date and time value rather than the calendar control.
4. Next you may use this textbox and pass it to data label or use it inside of the rules.
 

Resolution

This is known issue with existing workaround described above.




 

0 replies

Be the first to reply!

Reply