Date format from 45713 to DD.MM.YYYY

[gz]

Hi, I have variable vCurrMonthYear = num(MonthName(addmonths(today(),0))) how Can I change it to DD.MM.YYYY ?

[sandeep-singh · Accepted solution]

Instead of the NUM, use date function and format you want to use

Date(MonthName(addmonths(today(),0)),'DD.MM.YYYY')

[MarcoWedel · Accepted solution]

As AddMonths(date,0) leaves the date untouched (i.e. adding 0 months) your expression could be shortened to
MonthName(Today()).

Formatting as Date could be done like Date(MonthName(Today()),'DD.MM.YYYY').

Depending on your DateFormat variable you might as well use MonthStart(Today()) 

In case you actually want to add a number of months other than 0, you could do so using the second parameter of the MonthStart() or MonthName()  function, e.g. MonthStart(Today(),2).

hope this helps

Marco

[Rams- · Accepted solution]

Hi,

Instead of using :  vCurrMonthYear = num(MonthName(addmonths(today(),0)))

You can you: vCurrMonthYear = Date(MonthName(Today()),'DD.MM.YYYY')

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!