Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

FORMAT_DATETIME() date macro help

Updated: 21 May 2010 | 1 comment
djm0001's picture
0 0 Votes
Login to vote

I am trying to create a validation rule which does allow a user to make an incident due on Sundays. The easiest way that I can think of is to set it so that when datepart(weekday,workitem_due_on) = 7 there is an issue. since Sunday is represented by a 7. However, the validation rules do not like datepart but prefer FORMAT_DATETIME(datetime, output_format, input_format). I have no idea how to use this macro nor can i even find an example of it in use, can somebody please advise how I would simply be able to return the day of the week in a validation rule? Thanks

Comments

bgreen's picture
28
Sep
2009
0 Votes 0
Login to vote

Not needed

You shouldn't need to mess around with the FORMAT_DATETIME() macro.  Just use the HDQUERY[] macro to run your query.  Evaluate the results as a number in the validation rule.

Hope this helps,

Brad