Using variable information in Label

[#1]

I have created a variable called vBegDate and it looks like this in my load:

LET vBegDate = Num(makedate(year(Today()),1,1));

I have to use the first day of the first month for each year to do comparisons.

I would like to use this variable in a label that would say 'Beginning Value as of _________ (put the variable date here)

Is this possible to do????

[vgutkovsky]

Sure! You would just need to preface the text label with an equal sign to indicate that it's an expression:

='Beginning value as of ' & vBegDate

Regards,

Vlad

[#3 · Accepted solution]

Vlad Gutkovsky is correct. In addition you may want to wrap the vBegDate variable in the Date() function to get a formatted date instead of the date numeric number.

Examples:

='Beginning value as of ' & Date(vBegDate)

='Beginning value as of ' & Date(vBegDate, 'MM/DD/YYYY')