VPA- formla

Help Activities
,
1

Hello all,

I’m trying to do a VPA formla that wil help me during preparing the mutual fund recon in my work, i just to know what is the correct formla to use while changing the month every month as i will insert a new sheet every month and it should change accordginly

2

Hi @sadeem_2q

To get current month use this MonthName(Month(Now))

Month will give number
Monthname will give namw

Cheers

3

HI @sadeem_2q

This expression will give you the current month

Now.ToString("MMMM")

The above will return as November

Now.Month

The above will return as 11

Regards
Sudharsan

4

Hi @sadeem_2q

Try with this expression

Datetime.Now.Tostring("MMMM")

Result -> November

Datetime.Now.Tostring("MM")

Result -> 11

image

Regards
Gokul