Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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????
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')
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
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')