web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Datestamp MMMM-YYYYY
Power Apps
Answered

Datestamp MMMM-YYYYY

(0) ShareShare
ReportReport
Posted on by 504

I have this as my Date, can I make this as datestamp Today() October-2020 instead of 12/31/2001.

nagestiada_0-1593425150537.png

 

Categories:
  • eka24 Profile Picture
    20,925 on at

    Change the Format property of the DatePicker:

    "mmmm-yyyy"

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • nagestiada Profile Picture
    504 on at

    @eka24 

    Sharepoint get 1593360000000 instead of October 2020, do you know how can I convert?

     

    Thanks

  • eka24 Profile Picture
    20,925 on at

    I suggest you add a calculated column in sharepoint and convert the date column to October 2020.

    Then in PowerApps, save the full date instead of formatting to "mmmm-yyyy"

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • nagestiada Profile Picture
    504 on at

    Will I use a conditional statement that if 1593360000000 = October 2020? Or is there anyway on converting i believe this is a long date to date?

  • Verified answer
    eka24 Profile Picture
    20,925 on at

    What an saying is in powerapps, maintain the normal date: dd-mmm-yyyy

    Then create a calculated date column in sharepoint to to get the format: Month-year (mmmm-yyyy).

    So 2 columns, your usual date column dd-mmm-yyyy and another column which will calculate from the date column as month-year

    (=TEXT([Created],"mmmm"&" "&"yyyy")

     

    With the above, you will not have issues with 1593360000000.

     

     

  • danielbazetto Profile Picture
    Microsoft Employee on at

    Hi @nagestiada 

     

    Did the suggestion from @eka24  work in your scenario? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard