Hello Everyone,
I have a table stored in SQL Server. It has a date field and the value within this field is stored as '2018-12-04'
I have a UX linked to this table. Within this UX I have a label control that displays the date field. I want the date field to display as '12/04/2018'
I have tried setting the label control's "Display format" to time("MM/dd/yyyy",<value>).... doesn't work...date still shows up as 2018-12-04
I have tried setting the "Date Format" in the UX's properties to MM/dd/yyyy and then setting the "Display format" of the label control to time("{dialog.clientSideDateFormat}",<value>).... doesn't work...date still shows up as 2018-12-04
I have tried setting a session variable when the user logs in to 'context.session.__protected__clientSideDateFormat = "MM/dd/yyyy"'.... doesn't work...date still shows up as 2018-12-04
I have tried setting the label type property to "date", "time", and blank...
I've tried different combos of blank and populated on all of the above and still the display format is always 2018-12-4
I'm beginning to worry that there are so many different combos of settings, variables, and leaving blank that I might never luck into the right one.
If anyone could offer any insights on cracking this nut I would greatly appreciate it.
I'm using
o AA desktop version - 12.4.5.4.0, Build 5028
o IIS – Alpha Server Version 12.0.5028.0
o IIS - Windows Server 2016 Version 1607 (OS Build 14393.2155)
o SQL Server – 2014
I should mention the label is not data bound. The value is being pulled from the database in XBasic and then the label's value is being set in the same code block in the OnDialogInitialize event.
I have a table stored in SQL Server. It has a date field and the value within this field is stored as '2018-12-04'
I have a UX linked to this table. Within this UX I have a label control that displays the date field. I want the date field to display as '12/04/2018'
I have tried setting the label control's "Display format" to time("MM/dd/yyyy",<value>).... doesn't work...date still shows up as 2018-12-04
I have tried setting the "Date Format" in the UX's properties to MM/dd/yyyy and then setting the "Display format" of the label control to time("{dialog.clientSideDateFormat}",<value>).... doesn't work...date still shows up as 2018-12-04
I have tried setting a session variable when the user logs in to 'context.session.__protected__clientSideDateFormat = "MM/dd/yyyy"'.... doesn't work...date still shows up as 2018-12-04
I have tried setting the label type property to "date", "time", and blank...
I've tried different combos of blank and populated on all of the above and still the display format is always 2018-12-4
I'm beginning to worry that there are so many different combos of settings, variables, and leaving blank that I might never luck into the right one.
If anyone could offer any insights on cracking this nut I would greatly appreciate it.
I'm using
o AA desktop version - 12.4.5.4.0, Build 5028
o IIS – Alpha Server Version 12.0.5028.0
o IIS - Windows Server 2016 Version 1607 (OS Build 14393.2155)
o SQL Server – 2014
I should mention the label is not data bound. The value is being pulled from the database in XBasic and then the label's value is being set in the same code block in the OnDialogInitialize event.
Comment