News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Forma dateTime

Power Apps - Building Power Apps

Answered

Forma dateTime

(0) Share

Report

Report

Posted on by Giorgio67

145

Hi to everybody

in my Excel file I have a date field so format: 4/13/24 15:00 PM

and I need to convert in "yyyy-mm-dd" (only date with out time)

I need this to filter the list

Many thanks

Categories:

General Questions

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 145,434 on at

Like (0)

Report
Re: Forma dateTime

Hi @Giorgio67 ,

Try

Text(DateValue(YourDateField),"yyyy-mm-dd")

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps