Show Date Range for One & Two Weeks Prior
Hi All, I'm trying to make a rich text field that helps the user remember which dates to enter data for in the subsequent field. We have a field for two weeks prior, and one week prior. So, if the ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendto do date math you need to use duration units, such as seconds, minutes, hours or days.
ToText(FirstDayOfWeek(Today() - Days(14)))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
ToText(FirstDayOfWeek(Today() - Days(14)))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Once again... Thanks Mark!
------------------------------
Daniel Johnson
------------------------------
------------------------------
Daniel Johnson
------------------------------