Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have data related to leave forecast for April month.
here date is coming from excel ,here format is String.so i did formatting with Num# .
but here some dates are missing.
how to avoid missing dates issue?
Thanks,
!
i created master calendar to generate missing dates.
Working fine now.
Thanks,
Looks right to me... would you be able to share the this file? Leave_Forecast_Apr17
If the format is string and looks like a date field, use date# instead of num#
date(date#(<yourfiled>,'DD-MM-YY'),'DD-MM-YY') as date
this should convert your string type date column to date type date column.
Hope this helps!
In excel file No one applied leaves in 03-Apr-17,04-0-Apr-17 and 10 to 14 days in aplril
but these dates should show in report even though no one applied on those dates..
Thanks,
i created master calendar to generate missing dates.
Working fine now.
Thanks,