Answered

Refresh Now() in a label with timer

(0) Share

Report

Posted on by sanderson82

I have a one screen app with a gallery displaying on a tv screen and a timer set to refresh the data every hour. I've been asked to show date/time of the last refresh.

I've added a label with the text : "Last Refresh: " & Now()

Can someone advise how I can refresh the text in the label using the existing timer that refreshes my datasource?

Many thanks

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 68,271 Most Valuable Professional on at

Like (1)

Report

Re: Refresh Now() in a label with timer

Instead of using Now() in the label set the label to use the value of a variable. Then in the timerEnd property of the timer set the value of that variable to a formatted time string using Now(). That will automatically update the label.

Was this reply helpful? Yes No
sanderson82 97 on at

Like (0)

Report

Re: Refresh Now() in a label with timer

Thanks @Pstork1 I have attempted this but still no joy.

Screen1 OnVisible: Set(RTime,Text( Now(), "[$-en-GB]mm/dd/yyyy hh:mm" ))

Label: "Last Refresh: " & Text(RTime)

OnTimerEnd: Set(RTime,Text( Now(), "[$-en-GB]mm/dd/yyyy hh:mm" ))

Was this reply helpful? Yes No
Verified answer

Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report
Re: Refresh Now() in a label with timer

Try the following instead.

Set OnStart for the app instead of Screen onVisible to

set(RTime, Now())

Set the Label to

Concatenate("last refreshed: ",Text(RTime,"[$-en-GB]mm/dd/yyyy hh:mm" ))

Set the timerEnd to

set(RTime, Now())

Make sure timer is set to AutoStart

Was this reply helpful? Yes No
sanderson82 97 on at

Like (0)

Report

Re: Refresh Now() in a label with timer

@Pstork1 thank you! Working perfectly now

Was this reply helpful? Yes No