Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why this expression does not return a value in a text object?
date(Date#('01' & '/' & Month(ReloadTime()) & '/' & Year(ReloadTime()),'DD/MM/YYYY'))
Hi Pedro, try this: date(monthstart(ReloadTime()),'DD/MM/YYYY')
If you still want to use your code, you need to use a NUM for the month since this is a dual value, like this:
date(Date#('01' & '/' & NUM(Month(ReloadTime())) & '/' & Year(ReloadTime()),'DD/MM/YYYY'))
How about using Text().
Reference says Date() returns Date object.
Text(Date#('01' & '/' & Month(ReloadTime()) & '/' & Year(ReloadTime()),'DD/MM/YYYY'))