Skip to Content
0
Aug 12, 2016 at 07:45 AM

How to get month number from date?

43 Views

Hi All,

I wanted to get Month number from a date which i'm getting from prompt variable.

I cannot use substr() function to get month value as the date length will increase (i.e 11/30/2016).

I tried below formula and it doesn't work.

1.

2. Getting #ERROR on below two formula

=FormatDate(ToDate([Prompt_date];"dd/mmm/yyyy");"Mmm")

=FormatDate(ToDate([Prompt_date];"dd/mmm/yyyy");"dd/mmm/yyyy")

Attachments

date.PNG (2.5 kB)
date1.PNG (16.4 kB)