My Visual Database — How To Change Format Datetime In TableGrid

Re: How To Change Format Datetime In TableGrid

null@example.com (FMR) — Sun, 15 Jun 2025 21:42:10 +0000

prahousefamily wrote:

Thank You sparrow

I Try Solution 1 Create a calculated field with the TEXT field type And Use Query Converter Text To Format It OK ...
But
Solution 2 tnxdatecolumn(Form1.TableGrid1.Columns[с]).formatmask := 'yyyy-mm-dd hh:mm:ss'
Nothing has changed
It would be great if you could show me a sample project.

Don't forget add Script call on (OnChange) for TableGrid

Re: How To Change Format Datetime In TableGrid

null@example.com (sparrow) — Fri, 02 May 2025 06:45:38 +0000

I give you a really working code.
tnxdatecolumn(Form1.TableGrid1.Columns[с]).formatmask := 'yyyy-mm-dd hh:mm:ss';
I hope you substituted your column number instead of "с" in square brackets.

Re: How To Change Format Datetime In TableGrid

null@example.com (prahousefamily) — Fri, 02 May 2025 03:25:10 +0000

Thank You sparrow

I Try Solution 1 Create a calculated field with the TEXT field type And Use Query Converter Text To Format It OK ...
But
Solution 2 tnxdatecolumn(Form1.TableGrid1.Columns[с]).formatmask := 'yyyy-mm-dd hh:mm:ss'
Nothing has changed
It would be great if you could show me a sample project.

Re: How To Change Format Datetime In TableGrid

null@example.com (sparrow) — Thu, 01 May 2025 08:00:00 +0000

There may be several solutions:
1. Create a calculated field with the TEXT field type. In this field, you use the strftime() function to form the date sequence you need.
Output this calculated field to the table.
2. In the OnChange table event, write a command to change the display of the date and time. Something like this: tnxdatecolumn(Form1.TableGrid1.Columns[с]).formatmask := 'yyyy-mm-dd hh:mm:ss';

It should be noted that the second option, when large volumes of information are output to a table or Excel, MAY affect the speed
of displaying the results.

How To Change Format Datetime In TableGrid

null@example.com (prahousefamily) — Thu, 01 May 2025 06:15:50 +0000

How To Change Format Datetime In TableGrid ???