cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

storing datetime in datatable with 12 hours format.

AP_10343008
12-Amethyst

storing datetime in datatable with 12 hours format.

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 ?

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

 

View solution in original post

2 REPLIES 2

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

 

 

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

Top Tags