Excel JE Creator - Issue with Dates

Amy Brown
Amy Brown
Fourth Anniversary Kudos 1 Name Dropper Facilitator 1
in Blackbaud Financial Edge NXT® General Discussions

When I enter dates into Excel and then use the JE Creator, the dates change once the JE appears in NXT. I already made sure the column info is short date and not general. Any work around for this? How do I make sure my dates are correct?

Comments

  • Sylvia Cook
    Sylvia Cook
    Kudos 5 Fifth Anniversary Name Dropper Participant

    I noticed this today as well. Did you have a reversing date on the JE?

    I had only uploaded one JE today, which had a reverse date on it. Someone else had uploaded JEs without reversing dates and their posting dates were correct, so I am thinking it may have something to do with the reversing date.

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    I just tested this in a sample database and I got the same thing. I used a post date of 4/28/22. But when it uploaded it showed 4/27/22. Changed it by one day and I had no auto reverse date also. So seems like it could be affecting all FE databases, or the plug-in at least. I would advise bring this up to SUpport as they may not be aware

  • Amy Brown
    Amy Brown
    Fourth Anniversary Kudos 1 Name Dropper Facilitator 1

    I have a ticket. They are working on it.

Categories