missing dates while converting String into date

[Anonymous]

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,

!

[sunny_talwar]

Looks right to me... would you be able to share the this file? Leave_Forecast_Apr17

[manideep78]

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!

[Anonymous]

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,

[Anonymous · Accepted solution]

i created master calendar to generate missing dates.

Working fine now.

Thanks,