since ‎24-07-2020
‎25-09-2020
Anilr1717
Level 1
Date Format Function in Adobe Campaign Standard
Avatar

Anilr1717

Anilr1717
- Adobe Campaign Standard
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

129

Likes

0

Replies

0
Re: Currency Decimal Places
Avatar

Anilr1717

Anilr1717
- Adobe LiveCycle
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

70

Likes

0

Replies

0