Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i display only month and year when my data is refreshed?

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

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Use

  ='Data Last Refreshed on' & chr(13) & MonthName(reloadtime())

View solution in original post

7 Replies
nagaiank
Specialist III
Specialist III

Use

  ='Data Last Refreshed on' & chr(13) & MonthName(reloadtime())

deepakk
Partner - Specialist III
Partner - Specialist III

hi Sagar

Try this.

='Data Last Refreshed on' & chr(13) & Month(reloadtime())  & '-' & Year(reloadtime()) 

Deepak

Not applicable
Author

Hi Deepak,

Thanks a lot for your instant reply. This is what i was looking for.

Thanks once again.

Regards

Sagar Gupta

Not applicable
Author

Hi Krishna Moorthy,

Thanks a lot for your instant reply. This is what i was looking for.

Thanks once again.

Regards

Sagar Gupta

Not applicable
Author

Hey,

Is it possible to show time along with this?

Regards

Sagar Gupta

nagaiank
Specialist III
Specialist III

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')

Not applicable
Author

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