Skip to main content
16-Pearl
May 10, 2023
Solved

storing datetime in datatable with 12 hours format.

  • May 10, 2023
  • 1 reply
  • 1131 views

There is datetime field in datashape for storing dates in datatable. In datatable the datetime should be stored in 12 hours format without converting the datetime to string. How to do this ?

 

 

 

 

 

Best answer by Velkumar

Hi @AP_10343008 

 

I think it is not possible to store DateTime value in 12 hours format but while displaying you can convert it to 12 hours format and display it

 

Something like this

Velkumar_0-1683780539419.png

Actual value stored in DataTable

Velkumar_1-1683780571544.png

 

You need to specify DateTime format in Grid Column Renderer configuration (if you are going to display in Grid)

Velkumar_2-1683780688735.png

 

 

/VR

 

 

1 reply

Velkumar19-TanzaniteAnswer
19-Tanzanite
May 11, 2023

Hi @AP_10343008 

 

I think it is not possible to store DateTime value in 12 hours format but while displaying you can convert it to 12 hours format and display it

 

Something like this

Velkumar_0-1683780539419.png

Actual value stored in DataTable

Velkumar_1-1683780571544.png

 

You need to specify DateTime format in Grid Column Renderer configuration (if you are going to display in Grid)

Velkumar_2-1683780688735.png

 

 

/VR

 

 

5-Regular Member
May 16, 2023

Hello @AP_10343008 

 

Kindly revert if you have any further queries on this thread or accpt the given solution by @Velkumar for the benefit of other community Users.

 

Have a good day ahead!

 

Regards

Bhawna