Variable

[#1]

I have a table called  by name  "SUbscription ", which has many columns among which there is a column name called "Airtledated"  which has the formate like this

12-01-2014 , like this it has for 1 year . and in the same " Subscription table ther is a cloumn name called   product and ID .

Now i want to know how do i get the start date  and end date . from the date column. What kind of variable i need to define .

I already had this variable but its showing wrong  its giving the date as -2021

vstartdate =date(aggr(min(Airtledated),Airtel_product))

VEnddate= date(aggr(Max(Airtledated),Airtel_product))

Will some one help me plz . Iam stcuk badly .

Thanks in Advance

[tresesco]

A variable can't hold multiple values at a time. You might have to take a different route based on your requirement.

[#3]

They are different variables

[tresesco]

vstartdate =date(aggr(min(Airtledated),Airtel_product))

If you are trying to get start dates for every products (your aggr() made me think so), that means your trying to store multiple values in a single variable, that is not possible. If you want start date for a single seleted product, try without aggr() like:

vstartdate =date(min(Airtledated))

[#5]

how to add 2 vairables ?

is it like this

=$(vstartdate)+$(vendate)

     OR

(vstartdate)+(venddate)

[tresesco]

Concatenation operator is '&', like:

=$(vstartdate) &  $(vendate)

[#7]

does it give me the addition ?