Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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())
Regards
Sagar Gupta
Use
='Data Last Refreshed on' & chr(13) & MonthName(reloadtime())
hi Sagar
Try this.
='Data Last Refreshed on' & chr(13) & Month(reloadtime()) & '-' & Year(reloadtime())
Deepak
Hi Deepak,
Thanks a lot for your instant reply. This is what i was looking for.
Thanks once again.
Regards
Sagar Gupta
Hi Krishna Moorthy,
Thanks a lot for your instant reply. This is what i was looking for.
Thanks once again.
Regards
Sagar Gupta
Hey,
Is it possible to show time along with this?
Regards
Sagar Gupta
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')
Hi Krishna,
Can we change the color of text in such a way that half of it will be red and the other half in green.
For eg:
ABCDEFGHIJ
In the above example i want only 'ABCDE' in Red and rest in green.
Plz let me know if possible
Regards
Sagar Gupta