Set time to date time control
I have a date time control in a grid.Whenever a row is added I want to set the time to 5 pm default in the date time control.how to achieve this irrespective of the time zone of the operator ?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Hi Naziya,
Configure Run Data transform action for on click event on Add row link.In datatransform Use the following expression to set value to datetime property:
@String.toDateTime(@String.replaceAll(.pxCreateDateTime,@String.substring(.pxCreateDateTime,8,18),"T050000.000"))
Refer the datetime property in the UI.
In the above expression Indexes in the substring starts from T and ends with Milli seconds (20160912T11874344.323).You can adjust the index value accordingly.
But this is not working when we change the timezone. it shows different time according to different time zones of the operator
Hi Najiya,
What is the timezone for which you are trying to check?
Can you please share the screenshot of the date value for that timezone?
Use function pxGetSpecifiedTimeOnDate and see the usage of that function
Hi Najiya,
You can set the Default value for the DateTime Property.
Evita.