Date format with now() function

[#1]

How do I get the =now(0) -1 functio to display a date time in a text box. It currently displays a number like 40437.1243. I've tried various date formats with no success. Thanks.
Don

[googel84]

Hi dsluga, take a look to the attacched qvw.

I'd suggest the use of today() function instead of now, if your goal is to show only the date.

[googel84 · Accepted solution]

Here is the version with the entire timestamp.

Sorry for the misaunderstanding.

[#4]

Thank you for your help. I'll probably go with the now() function since I need to go to the hour and minute.

Don

[#5]

Try =date(now(0)-1)

[#6]

Thank you. That worked.