To get Month from Date

Help Activities
, ,
1

Hello people,

following is the query,
VAR1= 30-07-2021 (type: Generic)

I Need to get month and year value from above variable in this format - " July’21 "

Can anyone please provide solution to this

2

Hi!

Regards,
NaNi

3

Hi

you can try this

DateTime.ParseExact(VAR1.ToString,“dd-MM-yyyy”,Nothing).ToString(“MMMM”)+“'”+DateTime.ParseExact(VAR1.ToString,“dd-MM-yyyy”,Nothing).ToString(“yy”)

Result is July’21

Thanks
John

4

Hi,

Can you try the following?

DateTime.ParseExact(VAR1.ToString,"dd-MM-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM\'yy")

Regards,

2 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.