I looked over the calendar, it seems correct. One thing I noticed is that you are loading from resident campaignmetrics, in your script - but I don't see the table tag campaignmetrics: entered before your data load, which makes me believe you are not getting the actual or newly created date and it shows the original date field:
try this and reload.
date(floor(campaign_start_date),'MM-DD-YYYY') as campaign_start_date,
date(floor(campaign_end_date),'MM-DD-YYYY') as campaign_end_date,
SQL SELECT `batch_meta_data_id`,
I also attached my example - that does have the missing dates.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
1- Sales Analysis.qvf 352.0 K