Date

[Anonymous]

Why this expression does not return a value in a text object?

date(Date#('01' & '/' & Month(ReloadTime()) & '/' & Year(ReloadTime()),'DD/MM/YYYY'))

[pedrolau]

Hi Pedro, try this:  date(monthstart(ReloadTime()),'DD/MM/YYYY')

[pedrolau]

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

[mokitsu61]

How about using Text().

Reference says Date() returns Date object.

Text(Date#('01' & '/' & Month(ReloadTime()) & '/' & Year(ReloadTime()),'DD/MM/YYYY'))