Post

1 follower Follow
0
Avatar

Timesheet Query date of Time Entry

Both CreatedOn and ReportedDate do not return when the time entry was for. They return when it was entered. I see the correct dates in Clarizen timesheets but when I query it appears to return the date it was entered, not the date it was for. What is the field that represents the date the work was done on?

Bill Caughron Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Hi Bill,

ReportedDate should definitely represent the date the entry was for. 

You may be missing something in your code. 

Another idea: Perhaps you're experiencing a time zone based shift of the value. ReportedDate is a date only field, so the time portion of it is 00:00. Though in general Clarizen API time values are UTC based, for date only fields time zone doesn't apply, so you shouldn't apply the local time zone on the returned value.

If you're uncertain about some other field type, the best way to figure out the field type is to use DescribeEntitiesMessage (and locate the field in the results' Fields collection).

Hope this helps,

Ophir

Ophir Kenig 0 votes
Comment actions Permalink