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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

MannyVilla
MannyVilla
Offline

Badges

Badges
3

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
1

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by MannyVilla
Customize the badges you want to showcase on your profile
Re: BAAAM tool export date format - Adobe Audience Manager 14-07-2021
Hi @richlodge5 Here is the BAAAM Date formula: =((A2/1000)/86400)+(DATEVALUE("1-1-1970")-DATEVALUE("1-1-1900"))Make sure you replace the 'A2' to reference the the date cell you are trying to change. Also make sure that the raw (reference) date column (in this example 'A2') is formatted as general. The new date column will need to be formatted as 'Custom' and then you should make it: m:dd:yyyy AM/PM. It can get a bit wonky sometimes so if anyone else has a better way please share. Thanks,Manny

Views

526

Likes

0

Replies

0