storing datetime in datatable with 12 hours format.

[AP_10343008]

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 ?

[Velkumar · Accepted solution]

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

Actual value stored in DataTable

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

/VR

[bchaudhary]

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