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

Date format with time zone

Avatar

Avatar
Level 1
Shwetambra
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Shwetambra
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
View profile
Shwetambra
Level 1

07-05-2021

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 5
Level 2
taplondon_josh
Level 2

Likes

7 likes

Total Posts

14 posts

Correct Reply

5 solutions
Top badges earned
Affirm 5
Boost 5
Affirm 3
Boost 3
Boost 1
View profile

Avatar
Affirm 5
Level 2
taplondon_josh
Level 2

Likes

7 likes

Total Posts

14 posts

Correct Reply

5 solutions
Top badges earned
Affirm 5
Boost 5
Affirm 3
Boost 3
Boost 1
View profile
taplondon_josh
Level 2

13-05-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:

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