assigning date values from grid row selections gets the wrong date

This has been reported before, but it just does not seem to get addressed, even in 9.0.2.3.

If I have a date field in a grid, and I select that row and assign the value to a variable, it sets the date to the previous day. This happens if you happen to be ahead of GMT, as the date is actually returned as a UTC (?) date. If I am x hours ahead of GMT, this is interpreted as x hours before midnight, and makes it the previous day.

While this format may be useful (and may not be, depending on usage), it is utterly useless and in fact erroneous when the value is a date only (as is set in the designer). As such date only fields should not be interpreted like this.

Find more posts tagged with

BPM

Comments

Jerome_Pearce

Thanks for moving my posts - I can never seem to find the right link.

I would respectfully like to point out that this particular post is a bug, not a request, however.

Joe Smith

Jerome, this has beeen logged in our Feedback system and is being worked on by our development team.

Paul Lawrence

I reported this back in June, it has the folowing defect reference: DEF12739

Jerome_Pearce

June and still not addressed? That seems like an oversight...

Peter Pauckner

We have had to work around this problem and created a Server Script which we have promoted (example below) and then had to change the occurance of FormatDateTime(...) to CustomDateTime.FormatDateTime(..) throughout. Is there any better way to do this?

using System;

using System.Data;

using System.Collections.Generic;

using Metastorm.Ide.Extensibility;

using Metastorm.Runtime.Core;

using Metastorm.Runtime.Types;

using System.ComponentModel;

using System.IO;

namespace Metastorm.Runtime.Models.CustomNamespace

{

public class CustomDateTime

{

[Promote(PromotionTargets.ExpressionBuilder)]

[Category("Custom Date Time")]

public static string FormatDateTime(Metastorm.Runtime.Types.DateTime inDateTime, string inFormatString)

{

DateTimeOffset correctedDateTime = correctMtstmDateTime(inDateTime);

return correctedDateTime.ToString(inFormatString);

}

private static DateTimeOffset correctMtstmDateTime(Metastorm.Runtime.Types.DateTime inDateTime)

{

System.DateTime serverDateTime = System.DateTime.Now;

TimeSpan serverOffsetSpan = TimeZone.CurrentTimeZone.GetUtcOffset(serverDateTime);

double serverOffsetMins = serverOffsetSpan.TotalMinutes;

System.DateTimeOffset dateTime = inDateTime.ToDateTime();

TimeSpan clientOffsetSpan = dateTime.Offset;

double clientOffsetMins = clientOffsetSpan.TotalMinutes;

DateTimeOffset correctDateTime = dateTime.AddMinutes(clientOffsetMins - serverOffsetMins);

return correctDateTime;

}