Skip to main content
Solved

Updating a custom date field from SmartMail via the update_ejb activity

  • April 8, 2025
  • 3 replies
  • 38 views

jyork
Sidekick (Customer)
Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 80 replies

Does anyone know the correct date format to use to update a custom date field via SmartMail/update_event_ejb activity?

Per the wiki, it says it needs to be in the ‘YYYY-MM-DDTHH:mm:ss-OOOO ‘ format, which the value I’m passing is, but I can’t seem to get it to accept that date value no matter what I pass. I’ve tried the following:

2025-04-08T12:00:00.0000

2025-04-08T12:00:00-0000

date[2025-04-08 12:00:00.0000]

date%222025-04-08T12:00:00-0000%22

but none of these formats work. 

 

Best answer by Rajana

can you try this format : 2014-09-22T00:00:00Z

3 replies

Forum|alt.badge.img+7
  • Do Gooder (Customer)
  • 21 replies
  • April 8, 2025

Hello. 

I am not sure if this will be helpful to you or not, but we have been able to set date fields in our alua utilities (assystActionProcessor\runtime\alua3.19.8\alua.exe) using this format:

2025-04-08 13:45:00.000

These utilities do use the ASSYSTEJB, however we have not attempted this using SmartMail. 

Cheers, 

Duncan


Forum|alt.badge.img+5
  • Hero (Employee)
  • 35 replies
  • Answer
  • April 13, 2025

can you try this format : 2014-09-22T00:00:00Z


jyork
Sidekick (Customer)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 80 replies
  • April 14, 2025

That format worked, thanks!