Whay show like that i need to create a format for that column secound column
How is the date stored in the file? It looks like the date is stored in some packed date format, that may need to be unpacked first.
Thanks Len is istored in format of pvx is default dictionay for pvx i don't change nothing how i can unpacked ?
It looks like the year portion of the date was created using the "%A" format of the DTE() function.
ok ehat i need to do query take datas and who or i need change on format on column propeties
I'm not sure how your application is handling dates but if you enter the command:
DAY_FORMAT READ x$
x$ will contain the date format currently in effect.
For this example, the format is "YYYYMMDD" and the dates are stored in the data files this way.
A Query on the invoice file will print Invoice Dates as 20251013, 20240131 etc. if the InvoiceDate$ column is included.
The query definition allows you to press the Add Formula button to define a new column. I defined it as follows:
Column Title: Formatted Invoice Date
Formula: DTE(InvoiceDate$:"%D %Ml, YYYY")
Width: 20
Here is a help link for the Query Formula Definition dialog:
Query Formula Definition (https://manual.pvxplus.com/page/NOMADS%20Graphical%20Application/Dictionary-Based%20Development/Query%20Subsystem/Query%20Formula.htm)