How can i display only month and year when my data is refreshed?
what change do i have to make in this expression:
='Data Last Refreshed on' & chr(13) & timestamp(reloadtime())
='Data Last Refreshed on' & chr(13) & MonthName(reloadtime())
Hi Krishna Moorthy,
Thanks a lot for your instant reply. This is what i was looking for.
Thanks once again.
='Data Last Refreshed on' & chr(13) & Month(reloadtime()) & '-' & Year(reloadtime())
Is it possible to show time along with this?
Try the following expression in the textbox. You may modify the format expression as needed.
='last refreshed on ' & Chr(13) & Timestamp(reloadtime(),'MMM YYYY hh:mm')
Can we change the color of text in such a way that half of it will be red and the other half in green.
In the above example i want only 'ABCDE' in Red and rest in green.
Plz let me know if possible
Retrieving data ...