Calculation of Date field

[randhir]

hi,

i have one date filter field which stores current date ,i have made 31 date field which contains the auto enter calculation field which is

"11" & "/" & Month ( Date_Filter ) & "/" & Year ( Date_Filter )

but the result of date is not calculating properly it shows question marks.

I have attached the screen short

[comment]

Try using the Date() function to return a date, e.g. =

Date ( Month ( Date_Filter ) ; 11 ; Year ( Date_Filter ) )

Instead of 31 fields, consider one repeating calculation field =

Let ( [

d = Extend ( Date_Filter ) ;

] ;

d - Day ( d ) + Get ( CalculationRepetitionNumber )

)