Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Fetch Report - Dates Not Recognized as Dates RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have an rdl report using fetch. Several columns have dates. When I export the report to an Excel file the dates are not recognized as dates. When I do an ISNUMBER on such a cell it returns FALSE. When I double click the cell for editing and then exit without editing anything it is then recognized as date (the date then also aligns right instead of left before). Selecting the whole column and switching the type from General to Date does not help either. Why is this and how can I get this fixed?

    Btw, there are always two variable myDate and myDateValue. I use the former as I think that one is the one that gives me the local time instead of system time of the server. Conveniently it also gives me the actual date instead of date and time.

    Friday, May 10, 2013 10:49 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi hfaun,

    Believe adding an expression (in SSRS) on the cell and using the CDate function should get this work. 

    May want to also try setting the format on that particular cell to the desired date formatting 

    Give it a try and let me know how it goes :)

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    • Proposed as answer by Minal Dahiya Saturday, May 11, 2013 5:11 AM
    • Marked as answer by hfaun Wednesday, May 15, 2013 10:46 PM
    Saturday, May 11, 2013 12:46 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi hfaun,

    Believe adding an expression (in SSRS) on the cell and using the CDate function should get this work. 

    May want to also try setting the format on that particular cell to the desired date formatting 

    Give it a try and let me know how it goes :)

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    • Proposed as answer by Minal Dahiya Saturday, May 11, 2013 5:11 AM
    • Marked as answer by hfaun Wednesday, May 15, 2013 10:46 PM
    Saturday, May 11, 2013 12:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Any luck?

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Monday, May 13, 2013 6:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Finally got around to this. This did indeed work. Both the CDate and changing the text box property is necessary. Thanks a lot!
    Wednesday, May 15, 2013 10:46 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Aww glad to hear it! Thanks for following up! :)

    If this post answers your question, please click "Mark As Answer" on the post and/or "Mark as Helpful"

    Wednesday, May 15, 2013 11:26 PM