Discovered this on the prealpha server while trying to reproduce another issue with batches.
When editing a batch using the Financial Batch Detail (obsidian) block - it shows Batch Start and Batch End date/times that DO NOT match what is on the table for that batch. BUT if you enter a dates/time for these and hit Save - the values you entered WILL be saved correctly to the database. So it appears there is just an issue with how the block loads these fields from the table ... and it seems to be related to time-zone somehow. In other words - the values displayed for these fields are the GMT-x hours different based on the user's time zone. In my case it was either GMT-5 or GMT-6 depending on whether the date/time in the database was in daylight savings or in standard time.
Actual Behavior
The Batch Start date time and Batch End date time field displayed in the Financial Batch Detail block while editing DO NOT match what is stored on the databased.
Expected Behavior
The Batch Start date time and Batch End date time field displayed in the Financial Batch Detail block while editing SHOULD match what is stored on the databased.
Steps to Reproduce
Go to Financial/Batches
Select an existing Batch from the List
Edit the Batch and note what the Batch Start and Batch End fields are showing.
Use SQL to Select this same batch from the database
(NOTE: if you use Rock's SQL Command power tool by default it will only show the date for these 2 fields.
Use this to get the full date & time: CONVERT(varchar(40), BatchStartDateTime, 121) as 'BatchStartDateTime')
Compare dates.
Issue Confirmation
[X] Perform a search on the Github Issues to see if your bug or enhancement is already reported.
[X] Reproduced the problem on a fresh install or on the demo site.
Description
Discovered this on the prealpha server while trying to reproduce another issue with batches.
When editing a batch using the Financial Batch Detail (obsidian) block - it shows Batch Start and Batch End date/times that DO NOT match what is on the table for that batch. BUT if you enter a dates/time for these and hit Save - the values you entered WILL be saved correctly to the database. So it appears there is just an issue with how the block loads these fields from the table ... and it seems to be related to time-zone somehow. In other words - the values displayed for these fields are the GMT-x hours different based on the user's time zone. In my case it was either GMT-5 or GMT-6 depending on whether the date/time in the database was in daylight savings or in standard time.
Actual Behavior
The Batch Start date time and Batch End date time field displayed in the Financial Batch Detail block while editing DO NOT match what is stored on the databased.
Expected Behavior
The Batch Start date time and Batch End date time field displayed in the Financial Batch Detail block while editing SHOULD match what is stored on the databased.
Steps to Reproduce
Issue Confirmation
Rock Version
1.17.0.31
Client Culture Setting
en-US