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
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
