"if" formule

IF 1ST WEEK OF THE MONTH I WANT TO USE THIS ASSIGN DateTime.Now.AddMonths(-1).ToString(“MM”)

IF 2ND/3RD/4TH WEEK OF THE MONTH I WANT TO USE THIS ASSIGN
DateTime.Now.AddMonths(0).ToString(“MM”)

how to implement this IF function

1 Like

you can try this

  • use assign activity like this firstWeek = Cbool(DateTime.Now.AddMonths(-1).ToString(“MM”))

Cheers

i want use to both of the formula in one sequence, so i need to know how use this “IF” activity to do that

in VB, there is this function that returns the week number of the year (1 to 52):
DatePart(“ww”, Today).ToString
You can get this number and with another auxiliar table get what you want