Format System Variable &TOD in WebFOCUS Designer

[aromero]

Hello everyone,

I need to display AM/PM time format in a report heading. I am using the system variable &DATE and &TOD to display current date and time. The &TOD variable only display 24 hours' time separate by a period. Please check the attached images for better understanding. I am looking to display 12 hours' time.  I am new working with WebFOCUS. I tried to modify the variable using reporting language as various post suggesting here in the forum, and I only got an error message in WebFOCUS Designer. Is there a way to accomplish this in WebFOCUS Designer? Thank you!

[David Beagan]

There are an endless variety of system date variables. Here are some you may find useful:

 &DATEHHA               = 09AM
 &DATEHHIA              = 09:05AM
 &DATEHHIb              = 09:05 am
 &DATEHHISb             = 09:05:21 am
 &DATEHHISB             = 09:05:21 AM
 &DATEHHa               = 09am
 &DATEHHB               = 09 AM
 &DATEHHb               = 09 am
 &DATEHIS               = 05:21
 &DATEHHIS              = 09:05:21
 &DATE                  = 08/14/24
 &DATEHYYMDI            = 2024/08/14 09:05
 &DATEHYYMDBS           = 2024 08 14 09:05:21
 &DATEHMDYYS            = 08/14/2024 09:05:21
 &DATEHMtDYYI           = Aug 14 2024 09:05
 &DATEHMtDYYIB          = Aug 14 2024  9:05 AM
 &DATEHYYMDS            = 2024/08/14 09:05:21
 &DATEHYYMtDS           = 2024 Aug 14 09:05:21
 &DATEHYYMDIB           = 2024/08/14  9:05 AM
 &DATEHYYMDIa           = 2024/08/14  9:05am
 &DATEHYYMDIA           = 2024/08/14  9:05AM
 &DATEHYYMDSA           = 2024/08/14  9:05:21AM
 &DATEHYYMDSB           = 2024/08/14  9:05:21 AM
 &DATEHYYMDSb           = 2024/08/14  9:05:21 am
 &DATEHMDYYS            = 08/14/2024 09:05:21
 &DATXMtrDYY&DATEHHIA   = August 14, 2024 09:05AM
 &DATXMtrDYY&DATEHHIa   = August 14, 2024 09:05am
 &DATXMtrDYY&DATEHHIB   = August 14, 2024 09:05 AM
 &DATXMtrDYY&DATEHHIb   = August 14, 2024 09:05 am
 &DATXMtrDYY&DATEHHISA  = August 14, 2024 09:05:21AM
 &DATXMtrDYY&DATEHHISa  = August 14, 2024 09:05:21am
 &DATXMtrDYY&DATEHHISB  = August 14, 2024 09:05:21 AM
 &DATXMtrDYY&DATEHHISb  = August 14, 2024 09:05:21 am

 

[aromero]

Thank you!! I spent days looking for this. Works like a champ now. Where can I find information like this? 

[David Beagan]

Good question. In the Developing Reporting Applications manual (following link should take you to page 372)

https://docs.tibco.com/pub/wf-wf/9.2.3/doc/pdf/IBI_wf-wf_9.2.3_apps_language.pdf#page=372

You will see it mentions &DATEfmt  where fmt  can be any date or date-time. Although there are a few formats that might not work.

These formats are documented in the Describing Data manual. (following link should take you to page 140)

https://docs.tibco.com/pub/wf-wf/9.2.3/doc/pdf/IBI_wf-wf_9.2.3_dd_language.pdf?#page=140

 

 

[Patrick Huebgen]

23 hours ago, aromero said:

Thank you!! I spent days looking for this. Works like a champ now. Where can I find information like this? 

Another useful trick run those commands

? &

?  &&