Date field in (MMM/YYYY) format

[kevingeorget]

Hi PowerApp Users,

I have a requirement in my SharePoint list field to capture only the month and year without the day (E.g.-Aug/2019).

Is it possible with PowerApps.

If not with a date field, I can go ahead and use a single line of text field and tell user to populate in the format- MMM/YY. But how can i validate it.

Any help appreciated.

Thanks,

Kevin

[iAm_ManCat · Accepted solution]

Hi!

I think you're looking for something like this? (To autopopulate today's month/year into a SharePoint text field)

And if it's not going to be Today's date and you just want it to match a regex field, you could use this formula and Regular Expressions (regex) to determine if the text in the textbox matches mmm/yyyy :

That's
If(IsMatch(TextInput1.Text, "^\w{3}\/\d{4}"), "Date is in correct format", "Date format must be mmm/yyyy")

If neither of these options works for you then let me know a little more detail around what you're trying to achieve,

Cheers,

@iAm_ManCat