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

Anilr1717
Community profile Anilr1717 Level 1
Job title here
Location here
2 BADGES
Level 1

Level 1

Learn more
Joined the community 24-07-2020 2:59:42 AM
Offline
Top badges earned by Anilr1717
Customize the badges you want to showcase on your profile
Re: Date Format Function in Adobe Campaign Standard
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- Adobe Campaign Standard
Thanks Anil. That works for GetDate() but what happens if you apply the formula to a field in which the date is only present some of the time/ When the date is not present the value output into the field is 0/0/. Is there anyway to overcome this. I have tried various functions and nothing gets parsed.

Views

29

Likes

0

Replies

0
Re: Transpose data adobe campaign classic
Avatar
Give Back
Level 1
Anilr1717
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
View profile
Anilr1717
- Adobe Campaign Classic
Hi,You can use enrichment activity to do the transpose of data(rows to column). Please follow below steps.Step1: Take the enrichment activity and make the self join with same table with the help of 1: N join while giving join condition.Step2: While adding the data please make sure to add column(No. of records to retrieve as per your convenience (By default it will be max 3 rows) ). So it will create multiple enrichment table based on your records to retrieve. If you have chosen 3 then it will cr...

Views

94

Likes

0

Replies

0
Betreff: Currency Decimal Places
Avatar
Give Back 50
Level 4
Kosta_Prokopiu
Level 4

Likes

15 likes

Total Posts

52 posts

Correct reply

9 solutions
Top badges earned
Give Back 50
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile
Kosta_Prokopiu
- Adobe LiveCycle
🙂 I think there is an easier solution 12345/1000 on next lower cent: Math.floor(100*(12345/1000))/100 =>> 12.3412345/1000 on next higher cent: Math.ceil(100*(12345/1000))/100 =>> 12.35

Views

167

Likes

0

Replies

0