Expression Library

[av_one_full first min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’\’ margin=\’0px\’ mobile_breaking=\’\’ mobile_column_order=\’\’ min_col_height=\’\’ padding=\’\’ svg_div_top=\’\’ svg_div_top_color=\’#333333\’ svg_div_top_width=\’100\’ svg_div_top_height=\’50\’ svg_div_top_max_height=\’none\’ svg_div_top_flip=\’\’ svg_div_top_invert=\’\’ svg_div_top_front=\’\’ svg_div_top_opacity=\’\’ svg_div_top_preview=\’\’ svg_div_bottom=\’\’ svg_div_bottom_color=\’#333333\’ svg_div_bottom_width=\’100\’ svg_div_bottom_height=\’50\’ svg_div_bottom_max_height=\’none\’ svg_div_bottom_flip=\’\’ svg_div_bottom_invert=\’\’ svg_div_bottom_front=\’\’ svg_div_bottom_opacity=\’\’ svg_div_bottom_preview=\’\’ border=\’\’ border_style=\’solid\’ border_color=\’\’ radius=\’\’ column_boxshadow=\’\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_direction=\’vertical\’ background_gradient_color1=\’#000000\’ background_gradient_color2=\’#ffffff\’ background_gradient_color3=\’\’ src=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight=\’\’ highlight_size=\’\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ mobile_col_pos=\’0\’ id=\’\’ custom_class=\’\’ template_class=\’\’ aria_label=\’\’ element_template=\’\’ one_element_template=\’\’ show_locked_options_fakearg=\’\’ av_uid=\’av-29lywu\’ sc_version=\’1.0\’]

[av_heading heading=\’Expressions Library\’ tag=\’h1\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’entypo-fontello\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’\’ custom_font=\’\’ subheading_color=\’\’ seperator_color=\’\’ icon_color=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ headline_padding=\’\’ headline_padding_sync=\’true\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kwy3o1t4\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_textblock textblock_styling_align=\’\’ textblock_styling=\’\’ textblock_styling_gap=\’\’ textblock_styling_mobile=\’\’ size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kzwxez91\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
[wp_blog_designer id=\”2\”]
[/av_textblock]

[/av_one_full]

Using AddDays to return the Sunday date

{IIF(ReportData.Start_Time.DayOfWeek == DayOfWeek.Monday, ReportData.Start_Time.AddDays(6), IIF(ReportData.Start_Time.DayOfWeek == DayOfWeek.Tuesday, ReportData.Start_Time.AddDays(5), IIF(ReportData.Start_Time.DayOfWeek == DayOfWeek.Wednesday, ReportData.Start_Time.AddDays(4), IIF(ReportData.Start_Time.DayOfWeek == DayOfWeek.Thursday, ReportData.Start_Time.AddDays(3), IIF(ReportData.Start_Time.DayOfWeek == DayOfWeek.Friday, ReportData.Start_Time.AddDays(2), IIF(ReportData.Start_Time.DayOfWeek == DayOfWeek.Saturday, ReportData.Start_Time.AddDays(1), IIF(ReportData.Start_Time.DayOfWeek == DayOfWeek.Sunday, ReportData.Start_Time.AddDays(0), \”Error\” )))))))}}

Scroll to Top