Datum issue with excel connector (reports)

Languages Application language
1 
'Rooster': collection ['week'] {
	'week': text
	'van': number 'datum' @default: from 'datum en tijd' now
	'tot': number 'datum' = add ( .'van', ^ .'Presets'.'weekdagen' )

the date on the report displays another date rhen the date on the display
display shows 2024-10-01
report shows 05-11-8636
how to correct this?

furthermore, how to change the display date to 01-10-2024?

2

Can you show the numerical-types for the datum type?

And how do you produce the Excel report? Can you share your report definition where these datum type properties are being used?

3

For future reference: the issue was solved by using the as date number format in the report sheet definition, like this:

on from .'Names'
select
	'Week' : text ^ : 'week' as text
	'From' : number ^ : 'from' as date
	'To' : number ^ : 'to' as date
where
limit 1048575