Data field best practices

In Acumatica, a date field that is displayed in UTC is typically a field that is marked with the "PXDBDateAndTime" attribute. This attribute tells Acumatica to store the date in UTC format in the database, and to display it in the user's local time on the screen, taking into account the user's timezone setting.

On the other hand, a date field that is not displayed in UTC is typically a field that is marked with the "PXDBDate" attribute. This attribute tells Acumatica to store the date in the database without any time component and display it in the same format, regardless of the user's timezone setting.

To set up a date field that acts like a UTC value, you can add the "PXDBDateAndTime" attribute to the field in the DAC definition and use the "PXDBDateAndTime" attribute in the PXDBField attribute of the BQL Select statement.

To set up a date only field that does not act like a UTC value, you can add the "PXDBDate" attribute to the field in the DAC definition and use the "PXDBDate" attribute in the PXDBField attribute of the BQL Select statement.

Note: Acumatica also has a "PXDBDateTime" attribute that can be used in cases where the date and time is stored in UTC format in the database, but it is displayed on the screen in the user's local time without taking into account the user's timezone setting.

In order to manage, weather to use UTC, or not, take a look on UseTimeZone:

		/// <summary>Gets or sets the value that indicates whether the attribute
		/// should convert the time to UTC, using the local time zone. If
		/// <tt>true</tt>, the time is converted. By default,
		/// <tt>true</tt>.</summary>
		public virtual bool UseTimeZone
		{
			get { return _useTimeZone; }
			set { _useTimeZone = value; }
		}

Below goes sample of usage:

			#region LastSettlementDateUTC
			[PXDate(UseTimeZone = true)]
			[PXUIField(DisplayName = "Last Settlement Date UTC")]
			public virtual DateTime? LastSettlementDateUTC { get; set; }
			public abstract class lastSettlementDateUTC : PX.Data.BQL.BqlDateTime.Field<lastSettlementDateUTC> { }
			#endregion