Suggestion for additional template Date/Time variables
Posted: Tue Jan 12, 2016 12:24 am
Date selectors currently available for templates give only numeric values for day and month but do not give string values for day of week (e.g Monday, Tuesday...) or month (January, February...).
Would you consider extending the selectors at some point to include these options?
Possibly [DDD] gives abbreviated Mon, Tue, Wed ... whilst [DDDD] gives Monday, Tuesday, Wednesday ...
Similarly, [MMM] gives Jan, Feb, Mar ... and [MMMM] gives January, February, March ...
Alternatives to fit the current language patterns could be [enDDD], [deDDD], [nlDDD] etc.
It would at least save me from writing the following to get the number for day of week to use in a conditional expression (Sunday is 0, Monday is 1 etc)
Would you consider extending the selectors at some point to include these options?
Possibly [DDD] gives abbreviated Mon, Tue, Wed ... whilst [DDDD] gives Monday, Tuesday, Wednesday ...
Similarly, [MMM] gives Jan, Feb, Mar ... and [MMMM] gives January, February, March ...
Alternatives to fit the current language patterns could be [enDDD], [deDDD], [nlDDD] etc.
It would at least save me from writing the following to get the number for day of week to use in a conditional expression (Sunday is 0, Monday is 1 etc)
Code: Select all
{*([D] + (([M]<3) * floor(2.6*([M]+10) -0.2)) + (([M]>2) * floor(2.6*([M]-2) -0.2))+(([M]>3)*([YY] +floor([YY]/4) + floor([YYYY]/400) -2*[YYYY]/100))+(([M]<3)*([YY]-1 +floor(([YY]-1)/4) + floor([YYYY]/400) -2*[YYYY]/100)) ) % 7 *}