Announcements
'Pre-Order Time': If(!IsBlank(PreOrderTime.Text) && Trim(PreOrderTime.Text) <> "",DateAdd(DateValue(Text(Now(), "[$-en-US]yyyy/mm/dd")) + TimeValue(PreOrderTime.Text),TimeZoneOffset(Now()),Minutes),Blank()),
Patch(
Orders,
Defaults(Orders),
{
'Date/Time': Now(), // Ensure this remains DateTime
'Pre-Order Time': If(
!IsBlank(PreOrderTime.Text) && Trim(PreOrderTime.Text) <> "",
DateAdd(
DateValue(Text(Now(), "[$-en-US]yyyy-mm-dd")),
Value(Hour(TimeValue(PreOrderTime.Text))),
Hours
) + Time(
Hour(TimeValue(PreOrderTime.Text)),
Minute(TimeValue(PreOrderTime.Text)),
0
),
Blank()
)
}
)
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1