Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Date format with time zone

Shwetambra
Level 2
Level 2

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

1 Accepted Solution
taplondon_josh
Correct answer by
Level 2
Level 2

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:

taplondon_josh_1-1620918028350.png

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

taplondon_josh_0-1620917909419.png

Thanks,

Josh

 

 

 

 

View solution in original post

1 Reply
taplondon_josh
Correct answer by
Level 2
Level 2

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:

taplondon_josh_1-1620918028350.png

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

taplondon_josh_0-1620917909419.png

Thanks,

Josh

 

 

 

 

View solution in original post