Peroidtodatesum does not include end date?

Hi I’m trying to set up YTD calculation.

image

When I set up date to:
image

I found out there is a discrepancy and this seems like this is due to last day missing:

image

Is this normal - when I put YTD set date the logic is date <set date not date <=set date?
or am I missing something?

Thanks,

Hi @Liz, the discrepancy is because QS is taking the date 2022/05/31 as begining of the date, therefore, the YTDsum gives you data to the 2022/05/31 00:00:00, leaving the line for 2022/05/31 blank.
You can set the date to 06/01 or add one day to your formula.

Thanks!
Initially that’s what I thought so I have added truncdate to my date formula - would that not fix the issue?

Thanks,