Special Characters in Formatting

[#1]

Hi,

I need to add a "/" within my date format (script). Date('01.01.2015', 'MM/YYYY'), but I don't get the expected result. Instead the month is divided by the year.

Can someone help?

Tanks in advance!

[#2]

Doesn't work for me. When using the variable the value is null

[#3]

When using LET ReportingMonth = Date(replace(today(),'.','/'),'MM/DD/YYYY'); the result is "6,1670..."

[#4]

it does work in an expression but not in script

[vikramv · Accepted solution]

Hi,

U should use set.

Set ReportingMonth = date(date#(MonthStart(Today(),-1)),'MM/YYYY')

And then use as $(ReportingMonth)

Thanks,

Vikram.

[#6]

Thanks! I used "LET", but it works fine with "SET"

[Anonymous]

Hi,

if you use "LET" you don't have to use "$" when you want to display the value of the variable.

If you use "SET" yuo must use "$" when you use your variable.

Elena