How do I get the week ending date for a specific day?
How do I get the week ending date for a specific day?
| Answer | Assuming tdate contains the day you'd like to convert:
@If(tdate != ""; @Adjust(tdate; 0; 0; @Modulo(8 - @Weekday(tdate); 7); 0; 0; 0); tdate) |
| Attachments | -none- |
| Applies to versions | 3.x; 4.x; 5.x; 6.x |
| FAQ Provided By | ken yee |
| Credit | Click here for information source |
 | |
|
|