Category
Report Builder
Product Version
7.3
how to create a calculated field to determine weekdays from weekends
Answered
The same question
Glad to hear it and no problem!
Nathan
Glad to hear it and no problem!
Nathan
Hi Corey,
I would recommend something along the lines of the following free-hand SQL:
Let me know if this makes sense!
Regards,
Nathan
Hi Corey,
I would recommend something along the lines of the following free-hand SQL:
Let me know if this makes sense!
Regards,
Nathan
Thank you Nathan,
I will have to get back with you, I keep getting timed out when trying to run the calculation on my report. there may be an issue with my system. but before what I tried was creating a Pre-defined filed called "Day of week" and used the Week Day name field and the value was the submit date field so the days of week would actually say the days of the week, then I created a simple calculated field that is doing pretty much what you are telling me to do. but for some reason that did not work.
Thank you Nathan,
I will have to get back with you, I keep getting timed out when trying to run the calculation on my report. there may be an issue with my system. but before what I tried was creating a Pre-defined filed called "Day of week" and used the Week Day name field and the value was the submit date field so the days of week would actually say the days of the week, then I created a simple calculated field that is doing pretty much what you are telling me to do. but for some reason that did not work.
Hi Corey,
Sounds good, let me know if it starts working.
Hi Corey,
Sounds good, let me know if it starts working.
it is working now, I guess there was just something wrong with my system.
Thank You!
it is working now, I guess there was just something wrong with my system.
Thank You!
Glad to hear it and no problem!
Nathan
Glad to hear it and no problem!
Nathan
Replies have been locked on this page!