Skip to main content
Solved

Updating a custom date field from SmartMail via the update_ejb activity

jyork
Sidekick (Customer)
Forum|alt.badge.img+9
  • jyork
  • Sidekick (Customer)
  • 73 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

View original
Did this topic help you find an answer to your question?

3 replies

D
Do Gooder (Customer)
Forum|alt.badge.img+7
  • DuncanK
  • Do Gooder (Customer)
  • 15 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

R
Do Gooder (Employee)
Forum|alt.badge.img+4
  • Rajana
  • Do Gooder (Employee)
  • 27 replies
  • Answer
  • April 13, 2025

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

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

That format worked, thanks!

R
1 person likes this
  • R
    Rajana

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings