DateDiff
I need a formula that will search @activate and if the date is in the past 6 months and @issuecode is greater than 0 mark true. I have written doesn't compile. Any assistance would be greatly appreciated. I'm a rookie.
If(Contains(@"Activate", @"Activate") && DateDiff("m",@"Activate", Now()) <= 6 && @"UDF.Issue Code" > 0, "Valid", "Invalid")
0
Please sign in to leave a comment.
Comments
0 comments