Skip to main content
sameeru0003
August 31, 2023
Question

Max Date and time is not getting converted in appian

  • August 31, 2023
  • 8 replies
  • 0 views

Hi,

I have a date time field in DB stored with max value 9999-12-31 00:00:00.000000 i have a record type synced with this DB column field as date time type. when i am querying the record from Appian I am getting 4/10/2292 11:47 PM as result. when i verified the field in the record list this expression is used

if(
isnull(fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs']),
fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs'],
datetext(fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs'], "default")
)

8 replies

stefanhelzle0001
Brainy
August 31, 2023

As per the documentation Appian seems to support that.

https://docs.appian.com/suite/help/23.3/Appian_Data_Types.html#date

But, do you see the same behaviour without the datetext() call?

sameeru0003
August 31, 2023

Its the same 4/10/2292 11:47 PM

stefanhelzle0001
Brainy
August 31, 2023

When querying the data more direct, not synced, is it the same?

anmolv0003
August 31, 2023

It could be a time zone settings issue.