Which expression can be used to get month data stored in variable & previous month data?

Help
1

suppose in month variable we have 01 month.We want data of that month & previous month also. we want to get data of 01 month & 12th month as of now.Which expressions can we use here in assign activity?

Please guide if anyone knows

2

Hi @SUPRIYA123

Can you please explain from where do you want to get month data?
From a website or from somewhere else?

4

from excel data

5

can you please share that excel here?

6

test excel.xlsx (20.2 KB)

7

AddMonths(-1).ToString
use the above function.

1 Like
8

this expression we should use in filter datatable wizard.we have taken months(1) is string array variable.So add months is not member of string error is showing in filter datatable activity.

9

use Cdate(row(“Date”).tostring).AddMonths(-1)

10

not working row is not declared error is throwing at filter datatable activity

11

Check this XAML to get previous month-> DatePrevious.xaml (7.3 KB)

12

can u show me the xmal

13

In this month(1)=01 so we want previous month data from excel i.e december.we need to pass expression in this activity.

14

@SUPRIYA123

Make sure Month(1) is of type DataTime variable.

15

how to convert string array variable to date time variable.because if we take datetime variable,filter condition is not working in filter datatable activity wizard.

16

Cdate(month(1).tostring).adddays(-1)

17

ok.i have tried with this expression.Error is like below.

filter%20error

18

where is your full date???

19

we have full date in another variable.i.e like 01-31-2019.we split this date & fetched month value 01.this month we are using in filter condition.because full date format is not supporting in filter data table activity.

20

THIS DATE IS IN STRING only na??

21

this date variable type is generic value