Log in to AnswerLog in to Follow
UserImage.jpg
Mohamed Zubair Ahmed
39Views
2Comments
Date picker issue in Editable table
Question
Traditional Web
Application Type
Traditional Web

When I try to save the date picker in the editable table  by changing the date format to "MM/DD/YYYY" the date is getting saved, but when I refresh the page the input inside the table is displayed as MM/DD/YYYY.

But date needs to be displayed in the editable table. 

0
0
07 Mar 2022

Hi Mohamed,


Check that on the database you have the value saved in a Data or DateTime attribute and that you are saving the right value (e.g. 07/03/2022).


Then when showing on the screen, you should use the built-in function FormatDateTime and use the format MM/dd/yyyy, as described in the description of the function:


Just replace the DateTime variable in my example, for the attribute with the date you want to format.


Kind Regards,
João

0
0
07 Mar 2022

When saving the values it is stored as date but on the screen after refreshing the input field changed to MM/DD/YYYY

0
0
07 Mar 2022
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.