Fill missing data

[#1]

I am analysing some connection stats and need to know how many unique users are logged on each day. Some sample data is attached.

The problem I have is that a user's session may start on a Monday and end on a Friday, therefore I need to include all days from when their session started, through to when it ended.

How on earth do i go about doing that?

Can I do it in chart? Or do I need to do something in the dataload beforehand?

[#2]

I tried your way and also adpated this slightly Marco, but still no luck

If(IsNull(SessionClosed), Now()),Date(DayStart(Date(SessionClosed,'DD/MM/YYYY')),'YYYY-MM-DD') as SessionClosedDate,

The SessionClosed field is in the format DD/MM/YYYY HH:MM:SS

[MarcoWedel]

do you get error messages or just not the desired result?

It's hard to tell without information ...

regards

Marco