pcsoft.us.windevCopyright 2026, PC SOFT27 Oct 2017 15:07:00 Z26 Oct 2017 19:33:00 Z[attachment 2469 Capture1.JPG] I have a chart that displays counts for reservations sorted on a time field (last line). How is the best way to display the TIME in non-military time. (am/pm) In the base labels of a graph/chart? The data is built with a query. How would one build a formula to convert a time field into Am/Pm display within a query?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63151/read.awp27 Oct 2017 15:07:00 ZThanks. The single quotes is the key. The help documentation uses double quotes?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63151/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63151/read.awpChart with times. How to format not military timeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63147/read.awp27 Oct 2017 13:16:00 ZJim In your query add a calculated item and choose WLanguage functions. Syntax of item should beWL.DateToString(YourDate,'HH:M…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63147/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63147/read.awpChart with times. How to format not military timeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63144/read.awp27 Oct 2017 02:07:00 ZThanks Paulo. I have tried this. But I get errors when I try to add the format. Any examples would be appreciated. I am using W…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63144/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63144/read.awpChart with times. How to format not military timeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63143/read.awp26 Oct 2017 19:53:00 ZIf your database is HFSQL you can use WLanguage functions in the queries. try using WL.TimeToString in the query. https://…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63143/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63118-chart-with-times-how-format-not-military-time-63143/read.awpChart with times. How to format not military time