Joined the community
24-07-2020
2:59:42 AM
Online
Customize the badges you want to showcase on your profile
Date Format Function in Adobe Campaign Standard
Anilr1717
Level 1
0 likes
2 posts
0 solutions
Top badges earned
View profile
Anilr1717
- Adobe Campaign Standard
394
0
0
Likes
Total Posts
Correct Reply
Hi All, Putting some logic for Date Format function in Adobe Campaign
Standard. ToDate(LPad(ToString(Month(GetDate())),2 ,'0'
)+'/'+LPad(ToString(Day(GetDate())),2 ,'0' )+'/'+
ToString(Year(GetDate()))) ----MM/DD/YYYY (07/29/2020) Regards,Anil
Views
Likes
Replies
Re: Currency Decimal Places
Anilr1717
Level 1
0 likes
2 posts
0 solutions
Top badges earned
View profile
Anilr1717
- Adobe LiveCycle
146
0
0
Likes
Total Posts
Correct Reply
Hi, Just posting here so anybody can use it. 12345/1000 = 12.34 not
12.35 Code: 12.34 Floor(ToDouble(@CONTENT4)/1000)+'.'+Substring(
Iif(Length(ToString(Mod(ToDouble(@CONTENT4),
1000)))<=1,LPad(ToString(Mod(ToDouble(@CONTENT4), 1000)),3 ,'00'
),Iif(Length(ToString(Mod(ToDouble(@CONTENT4),
1000)))=2,LPad(ToString(Mod(ToDouble(@CONTENT4), 1000)),3 ,'0'
),ToString(Mod(ToDouble(@CONTENT4), 1000)))),1,2 ) Code: 12.35
Round(ToDouble(12345)/1000,2) Regards,Anil
Views
Likes
Replies