Focal Point
[SOLVED]Formating Datetime value without seconds

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2557009386

September 16, 2016, 02:27 PM
Denny99
[SOLVED]Formating Datetime value without seconds
Is there a way to format a datetime field in a format similar to MM/DD/YYYY HH:MM.

Many thanks!!

This message has been edited. Last edited by: <Emily McAllister>,
September 16, 2016, 02:34 PM
MartinY
DEFINE FILE CAR
DTHM/HMDYYI='20160916 02:33';
END
TABLE FILE CAR
BY  COUNTRY
BY  DTHM
WHERE READLIMIT   EQ 1;
WHERE RECORDLIMIT EQ 1;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
END



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
September 16, 2016, 02:34 PM
CoolGuy
See the following: Usage Formats


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.