Now.ToString(“d-MMM-yyyy”) is working odd

Help
, ,
1

Hey everyone,

I try to write cell the date of today, I tried, Now.ToString(“d-MMM-yyyy”), its giving 24.35.2020 as output, is there anyother way for me to get date? or can I fix this?

Ty,

2

Maybe cell format of your excel can be issue.

3

when ı do Now.ToString("d-MMM-yyyy hh:mm), its working fine but it writes Nov. as in November I need it to write 11. Other than that is there anyway I can make sure its not about the excel?

4

if you want to write 11, you need to set format to MM, not MMM

5

have you tried like this?
image

6

Now.ToString(“d-MMM-yyyy”)

image

It’s working fine for me…

7

Please go through this

MMM - Nov
MMMM - November
MM - 11

8

okay, yes I was just playing with it and figured it out

9

Thank you @Pradeep_Shiv @Mulya_Habibi_Tullah

1 Like
10

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