Skip to main content
Shwetambra
Level 2
May 7, 2021
Beantwortet

Date format with time zone

  • May 7, 2021
  • 1 Antwort
  • 1532 Ansichten

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

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von 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 Antwort

tapcxm_josh
tapcxm_joshAntwort
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

 

 

 

 

Allgemeine NutzungsbedingungenAccessibility statement

Loading footer...