Moving to customization thread.
Formula to get week day number (1-7) and current hour (0-23) value?
Hello Clarizen community,
we have been checking the posts as well documentation but were not able to find the function(s) to get a couple of values out of the current date (Now()):
- we need to know the current day number of the week (1 to 7, or "Mon" to "Sun", does not really matter) to make a conditional behavior on a workflow
- we need to know the current hour out of Now() (0 to 23) to make a conditional behavior on a workflow
Please share if you have an idea!
Thanks in advance!
Please sign in to leave a comment.
Anyone? Maybe there is some workaround or another approach?
From the business flow point of view what we are looking for is a way to define what are going to be the recipients for the email alert when new issue/bug is posted in clarizen and it should be based on teh day of the week and time of a day.
1) This will give you the day of the week as an abbreviation of the weekday name in the string format (feel free to change "Mon", "Tue", etc. values into numbers, but don't forget to replace "Function failed!" with a number as well, otherwise, the function won't work):
Mod(Floor(DateDiff(Date, Date(1901, 1, 1), "d")), 7),
2) This will give you the value of current time as an integer in the 24h format (e.g. 0, 7, 11, 19, 23, etc.):
ToNumber(Left(Right(ToString(Now()), 8), 2))
Please let me know if this answers your question.
Sorry, forgot to replace one variable (Date >> Today()):
Mod(Floor(DateDiff(Today(), Date(1901, 1, 1), "d")), 7),
Please let me know if this is helpful.
Thank you Roland,
I was able to leverage your mathematical prowess within a report HIGHLIGHT leveraging the FORMULA options inside of a CUSTOM summary type. Probably too complex for something so simple; but VERY cool for our end users to see a timer for when something is going to run, so thank you...