Skip to main content
June 26, 2025
Question

Time - Prior11 -- newest to oldest

  • June 26, 2025
  • 1 reply
  • 0 views

Is there a way to pull time in newest to oldest?

T#|CVTime|.Prior11 ---- Pulling M4 on an Oct - Sep 2025 calendar.

This will pull Feb 24, Mar 24, Apr 24, May 24, Jun 24, Jul 24, Aug 24, Sep24, Oct 25, Nov 25, Dec 25.

How do I pull the opposite - Dec 25, Nov 25, Oct 25, Sep 24, Aug 24, Jul 24, Jun 24, May 24, Apr 24, Mar 24, Feb 24?

1 reply

June 26, 2025

I would use an XFBR that reverses the order.  

Something like 
Given that input is  "Feb 24, Mar 24, Apr 24, May 24, Jun 24, Jul 24, Aug 24, Sep24, Oct 25, Nov 25, Dec 25"

code the reverse as:
Dim reversed As String = String.Join(", ", input.Split(","c).Select(Function(s) s.Trim()).Reverse())
Return reversed

Edit: I just realized this is an ideastream.  oh well, there's a suggestion.