How to return the day os the week (e.g. "Monday") based on the date of the module

Hi,

I have module with time scale "day". I have a line item called: Workday, and I need it to return the day of the week (e.g. "Monday") based on the date of the module. I need this so that the person has to tick only the weekdays.

Can you help me ?

Thank you in advance!

Accepted answers

BrunoRodriguez

Hello @Brfonseca,

I believe you are after something like the below?

In such a case, you need to create a fake list for the days as per below:

And then the last step would be to make a FINDITEM. Remember that it requires text, so you would need to convert the "Year text" into text. You can use TEXT() to do so.

Finally, if the day number that goes from 1 to 7 is below equal or below 5, a boolean could be ticked.

I hope the above is clear!

All comments

aakash

Hi @Brfonseca,

I think the function you need to use is 'WEEKDAY'

Here you go → https://help.anaplan.com/a445eb44-98b7-4abc-8748-92435187e423-WEEKDAY

Regards,

Aakash Sachdeva

BrunoRodriguez

Hello @Brfonseca,

I believe you are after something like the below?

In such a case, you need to create a fake list for the days as per below:

And then the last step would be to make a FINDITEM. Remember that it requires text, so you would need to convert the "Year text" into text. You can use TEXT() to do so.

Finally, if the day number that goes from 1 to 7 is below equal or below 5, a boolean could be ticked.

I hope the above is clear!

Brfonseca

Hello @BrunoRodriguez , That's exactly what I want! Thank you !!
Can you show me the module in blueprint mode, in order for me to check the formulas of each line item, please?

BrunoRodriguez

Hello @Brfonseca ,

Cheers!

Brfonseca

Many thanks @BrunoRodriguez !!

Quick Links

Can you help?

Unanswered questions

How can I add more than one assignee to a Offline task when creating a Workflow task?
I not being able to add 2 assignees when creating an Offline Task when crating a Workflow template. Do I need to crate 2 separate offline tasks, one for each user? Thanks.
I am getting error while submitting the assignment,please give me suggestion.
Please suggest why it is not taking submit.
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…