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

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

storing datetime in datatable with 12 hours format.

AP_10343008
15-Moonstone

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 ?

 

 

 

 

 

ACCEPTED SOLUTION

Accepted Solutions
Velkumar
19-Tanzanite
(To:AP_10343008)

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
Velkumar
19-Tanzanite
(To:AP_10343008)

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

Announcements


Top Tags