Convert DateTime field to Date and then Preform a Count

[LDickenson]

Hi

I have a field that is a datetime field, I need to convert this to a date field as I need to preform a count on how many records for each day per month, at the moment it is counting how many datetime and therefore is showing hundreds of records per day when I just want it to count 1 record per day.

Any help appreciated.

Thanks,

Lisa

 

[IanWaterman]

Not sure what you are saying.

Can a uniqueID have many datetime entries within a day?

If yes then just do a Running Total which does a distinct count of your ID each day.

If this is not what you want please explain more.

Ian

 

[LDickenson]

Hi

Sorry for not being clear:-

What we are trying to do it count how many times someone has logged into a system in a particular week but only want one record per day, the field that shows when the user logged in shows one record for every key stroke they took that day and records the time against it, we want to convert the datetime to just a date so we can count 1 per day rather than every key stroke.

Thanks,

Lisa

 

[LDickenson]

Thanks sorted now with a forumla

 

[lbass]

Please show your solution so this thread becomes valuable to others.

-LB

 

[LDickenson]

Formula used

CDate ({TABLE.FIELD})