Answered

Date format is not changing on card

(0) Share

Report

Posted on by BradKCox

Hi All,

I cannot seem to change the format of a card on a form from Dynamics Nav, i have tried using a text format function with success in other areas of the app and no issues at all. I have attached what is on the app at this time but this seems now not to work. I have also used a text short date format but this hasnt worked either and i cannot seem to figure this one out on my own.

2019_06_06_12_01_49_Holiday_Form_Working_O365_Intergration_Saved_Unpublished_PowerApps.png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

what is Default.Parent ? is it the today date ?

if so, try this <<Text(Today();"[$-en-GB]mm/dd/yyyy")>>
without the << >>
today is 06-06-2019, so to distinguish between day and month try <<mm/d/yyyy>> or <<m/dd/yyyy>>.
Let us know how it goes 🙂

Was this reply helpful? Yes No
BradKCox 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for the reply, it is a Parent.Default, i have tried this but with no luck.

Was this reply helpful? Yes No
Verified answer

BradKCox 36 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks but a developer friend helped me resolve this one with a logic fix.

Below is what the code does in the background, its not perfect but is gets the job done.

If(And((Len(Mid( Parent .Default,Find("/", Parent .Default)+1,Find("/", Parent .Default,Find("/", Parent .Default)+1)-1-Find("/", Parent .Default))))=1,(Len(Left( Parent .Default,Value(Find("/", Parent .Default))-1))=1)),
Concatenate("0",Mid( Parent .Default,Find("/", Parent .Default)+1,Find("/", Parent .Default,Find("/", Parent .Default)+1)-1-Find("/", Parent .Default)),"/0",Left( Parent .Default,Value(Find("/", Parent .Default))-1),"/",Right( Parent .Default,4)),
If(Len(Mid( Parent .Default,Find("/", Parent .Default)+1,Find("/", Parent .Default,Find("/", Parent .Default)+1)-1-Find("/", Parent .Default)))=1,
Concatenate("0",Mid( Parent .Default,Find("/", Parent .Default)+1,Find("/", Parent .Default,Find("/", Parent .Default)+1)-1-Find("/", Parent .Default)),"/",Left( Parent .Default,Value(Find("/", Parent .Default))-1),"/",Right( Parent .Default,4)),
If(Len(Left( Parent .Default,Value(Find("/", Parent .Default))-1))=1,
Concatenate(Mid( Parent .Default,Find("/", Parent .Default)+1,Find("/", Parent .Default,Find("/", Parent .Default)+1)-1-Find("/", Parent .Default)),"/0",Left( Parent .Default,Value(Find("/", Parent .Default))-1),"/",Right( Parent .Default,4)),
Concatenate(Mid( Parent .Default,Find("/", Parent .Default)+1,Find("/", Parent .Default,Find("/", Parent .Default)+1)-1-Find("/", Parent .Default)),"/",Left( Parent .Default,Value(Find("/", Parent .Default))-1),"/",Right( Parent .Default,4)))))

Was this reply helpful? Yes No