How to show the filedate in the text at top when selecting specific product.

[suvechha_b]

Hi All ,

How to show the filedate in the text at top when selecting specific product.

But when we are not selecting the product code . the filedate are showing.

sample model attached.

[tresesco · Accepted solution]

Try removing the $ expansion like:

= 'Aspen Data Refresh: ' & TimeStamp(vAspenDist,'YYYY-MM-DD HH:MM          ') &

'IHS Data Refresh: ' & TimeStamp(vIHS,'YYYY-MM-DD HH:MM                    ') &

'PIN Data Refresh: ' & TimeStamp(vPIN,'YYYY-MM-DD HH:MM                    ') &

'NRP Data Refresh: ' & TimeStamp(vNRP,'YYYY-MM-DD HH:MM                    ') &

'SCS Data Refresh: ' & TimeStamp(vSCS,'YYYY-MM-DD HH:MM                    ') &

'ULG Data Refresh: ' & TimeStamp(vULG,'YYYY-MM-DD HH:MM                    ') &

'UPD Data Refresh: ' & TimeStamp(vUPD,'YYYY-MM-DD HH:MM')

[sunny_talwar]

Not sure if above is what you want, but also make sure to use hh:mm vs HH:MM because capital M (MM) is used for months and lower case m (mm) is used for minutes.

[Anonymous]

Try Below one, it is working

= 'Aspen Data Refresh: ' & TimeStamp((vAspenDist),'YYYY-MM-DD HH:MM           ') &

'IHS Data Refresh: ' & TimeStamp((vIHS),'YYYY-MM-DD HH:MM                    ') &

'PIN Data Refresh: ' & TimeStamp((vPIN),'YYYY-MM-DD HH:MM                    ') &

'NRP Data Refresh: ' & TimeStamp((vNRP),'YYYY-MM-DD HH:MM                    ') &

'SCS Data Refresh: ' & TimeStamp((vSCS),'YYYY-MM-DD HH:MM                     ') &

'ULG Data Refresh: ' & TimeStamp((vULG),'YYYY-MM-DD HH:MM                    ') &

'UPD Data Refresh: ' & TimeStamp((vUPD),'YYYY-MM-DD HH:MM')