Getting date from Week number and day

(0) Share

Report

Posted on by jenks540

I have two fields in CRM representing a day of the week (day spelled out in text) and week of the month (numeric value 1-4). Getting curent year is not a problem. The idea is to represent a very specific day of each month we will perform an action.

I want to turn that into a date value and update a separate date field each month with the correct date for that particular month. I have hit a wall so here I am asking for an assist :-).

I have played around with calculated date fields and the various workflow utilities and have not been able to accomplish much.

Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi jenks540,

It think it is a better idea to create a single date field and compare the date field to the current date on a regular basis. Then execute your logic when the date field exceeds the current date.

I think it is important to point out that there are typically more than four weeks in a month, and there are other reasons why your text approach will create unnecessary complexity.

Was this reply helpful? Yes No
jenks540 45 on at

Like (0)

Report

Thanks for the reply.

I am not seeing how I could make sure something is executed on say, "Wedensday of the third week of every month" with that method. Can you elaborate a little bit? Thank you!

Was this reply helpful? Yes No
Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi jenk540,

I was under the impression that you only wanted to execute the logic once.

Consider executing your logic from a reoccurring SQL Server Agent Job instead of directly from Dynamics CRM. By customising a SQL Server Agent job, you can choose the particular days you want to run your logic.

Was this reply helpful? Yes No
jenks540 45 on at

Like (0)

Report

This is CRM online - so, no access to SQL Agent jobs

Was this reply helpful? Yes No
Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi jenks540,

You will still be able to make use of SQL Server Agent Jobs if you have SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).

Was this reply helpful? Yes No
jenks540 45 on at

Like (0)

Report

Yes, of course. But, will go there as a last resort. Would prefer to keep this in CRM if possible. Thanks

Was this reply helpful? Yes No
Verified answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

I don't think you will be able to get anything out of box or any utility to achieve this. You will need to write your own custom code (plugin/ JavaScript etc) to get the date out of this.

Hope this helps.

Was this reply helpful? Yes No
jenks540 45 on at

Like (1)

Report

I think you are right. I would not mind changing things slightly to "third Wednesday of the month" but i still don't think I can achieve without custom code. I was hoping I was missing something with the various workflow utilities.

thanks to you both.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

Yes, let us know if you go for plugin and needs any help.

Was this reply helpful? Yes No

Community site session details

Getting date from Week number and day

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Getting date from Week number and day

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates