CSV Reports - Date Format

oldgeekMember

I am trying to use the Auctiva CSV Reports (BETA), but have a problem sorting by date. The generated format for this field is "Weekday, day, year, time AM/PM", however Excel does not recognize that as a date format, so I am unable to sort on that column. It is not even possible to cast those as a date by formatting the cells. An attempt to sort by date doesn't work, it will give a string sort, with all the Monday values first, etc. What I am doing now is a search and replace for each of the 7 weekday names, which is not efficient.

So, unless someone can tell me what I am missing here, I guess this is a suggestion to allow that field to be formatted by the user. Come to think of it, even without the weekday having a fixed format is problematic because some countries use a different date format, and month names are not the same.

5/9/095:34 PM

Original Post

<ul id="{%=id%}ButtonGroup" class="button-group h-popup-buttons even-button-group even-1">
    <li id="{%=id%}Okay_buttonContainer"><a id="{%=id%}Okay" href="javascript:void(0);" class="button success no-margin-bottom h-alert-modal-ok-button" role="button">OK</a><script type="text/javascript">
        (function() {
            function {%=id%}Okay_click(event, data) {
            {%=id%}Popup.hide();
        }
        
                $('#{%=id%}Okay').on('click', {%=id%}Okay_click);
        })();
    </script></li></ul><a href="javascript:void(0);" class="close-reveal-modal" aria-label="Close Modal">&#215;</a><div class="last-modal-focus focus-utility-element" tabindex="0"></div>
</div>
<script type="text/javascript">
        (function() {
            {%=id%}Popup = new SS.Popup.ModalPopup('{%=id%}');
        })();
    </script>

Skip to main content

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...