Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
16 replies
Subscribers
8 subscribers
Views
11270 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Set value to a date time variable on saving a date field
arjunv
over 8 years ago
Hi All,
I have a scenario where there is a date field and once a date is entered, a date and time field should replace a date field with a defaulted time and the date.
If I remove either date or time in the date time field, it should again go back to a empty date field. Following is the code
load(
local!dt1,
local!dtTm1,
if(isnull(local!dt1),
a!dateField(
label:"date",
value:todate(local!dt1),
saveInto:{local!dt1,a!save(local!dtTm1,gmt(todatetime(save!value & " " & "16:00")))}
),
a!dateTimeField(
label:"dateTime",
value:todatetime(local!dtTm1),
saveInto:{local!dtTm1,local!dt1}
)
)
)
But when I again enter a date in the date field, the date and time field populates with a previously entered date and time instead of current chosen one. Is there any other way to implement this?
Thanks in advance.
OriginalPostID-251525
Discussion posts and replies are publicly visible
Parents
0
Sally Mason
Appian Employee
over 8 years ago
Also, when using GMT, you should specify the zone if you are not GMT 0. Also note the format Appian expects for the time: am/pm, not 24:00hr time.
Eg for the 7th of December at 1pm Eastern Standard Time (GMT-05:00) would be:
gmt(todatetime("12/07/2016 1:00 pm"), "EST")
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sally Mason
Appian Employee
over 8 years ago
Also, when using GMT, you should specify the zone if you are not GMT 0. Also note the format Appian expects for the time: am/pm, not 24:00hr time.
Eg for the 7th of December at 1pm Eastern Standard Time (GMT-05:00) would be:
gmt(todatetime("12/07/2016 1:00 pm"), "EST")
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data