Post

2 followers Follow
1
Avatar

Date conversion to Week

I have a user that is trying to create a calculated field on a report. in this field she wants to convert a date to a week value. for example any date between 9/2/2018 to 9/8/2018 would convert to week 36. '36' being the number of weeks in the calendar year. 

Has anyone used this before?  If so can you let me know if This can be calculated or if a custom field is required?

Kimberly Coates

Please sign in to leave a comment.

2 comments

0
Avatar

Week is one of the standard functions available within the workflows.  Personally I would create a custom field to contain the week number of the date field you require and then include this in your report.

Phil Smith 0 votes
0
Avatar

I am working on the custom field but the functions available are not as clear cut as I expected in order to create a conversion script.  I am looking for direction on the coding syntax to be used.

Kimberly Coates 0 votes