Date format with time zone | Community
Skip to main content
S
Shwetambra
Level 2
May 7, 2021
Solved

Date format with time zone

  • May 7, 2021
  • 1 reply
  • 1509 views

I want to read a file that has date-time in it and I want to pass it in the delivery formula to optimize send times.

Can someone please suggest the correct date format to feed? Does Adobe want specified timezone too?

 

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by tapcxm_josh

Hi @shwetambra ,

You can read datetime values into Adobe Campaign in many different formats, you just need to make sure that the values brought into ACS from the file are being stored in a datetime field.

In the Load File activity, once you've uploaded a sample file, you can see the columns that will be created in the workflow under the Column Definition tab. Edit the column, change the data type to datetime, and specify the format that the date values take in the file:

The field will now show of type date and time and can be used within a delivery for send time optimization:

Thanks,

Josh

 

 

 

 

1 reply

tapcxm_josh
tapcxm_joshAccepted solution
Level 2
May 13, 2021

Hi @shwetambra ,

You can read datetime values into Adobe Campaign in many different formats, you just need to make sure that the values brought into ACS from the file are being stored in a datetime field.

In the Load File activity, once you've uploaded a sample file, you can see the columns that will be created in the workflow under the Column Definition tab. Edit the column, change the data type to datetime, and specify the format that the date values take in the file:

The field will now show of type date and time and can be used within a delivery for send time optimization:

Thanks,

Josh

 

 

 

 

Terms & ConditionsAccessibility statement

Loading footer...