Date and Weekday

[tracycrown]

Dear Sir

Can someone advise me why Jan 1, 2024 is missing after loading data from Excel.xlsx and why 'Monday' in all months are also missing ?.

Wishing you and your family a Happy New Year 2014!

Date	Cdate
01-01-2024
02-01-2024
03-01-2024
04-01-2024
05-01-2024
06-01-2024
07-01-2024
08-01-2024
09-01-2024
10-01-2024
11-01-2024
12-01-2024
13-01-2024
14-01-2024
15-01-2024
16-01-2024

Many Thanks, Tracy

[anat · Accepted solution]

as in table you can uncheck "Suppress zero-Values " option then you can see Monday as well 1/1/2024 records...

but ideally it should not happen,,

[anat]

Or else you can generate day, month, week name etc... In load script like

Load day(date) as day, 

Week name(date) as week name

Etc....