Answered

Error in formula: Text(Today() Try and revise it

(0) Share

Report

Posted on by MrsDunlap

When creating a data card. I keep getting an error in the formula for the Text(Today(), "yyyymmdd"). It states that there is an error in the formula. Try and revise it. Am I missing something that would correct this issues? I really appreciate any assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

TheRobRush 11,128 Moderator on at

Like (0)

Report

I mean, that formula is correct, to provide a string that looks like a date. What kind of column is connected to that data card? if its just a text column the error is not in the provided code but elsewhere

Was this reply helpful? Yes No
MrsDunlap 25 on at

Like (0)

Report

Here is a screenshot of the error. I don't know what I have done wrong.

Screenshot 2023-0...

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

Can you use Snipping tool to screengrab that entire line of code and then paste it into the forum response and then click the expand square below it to make usre it is full size? however you shared that its become so artifacty/pixelated that its not legible anymore

Was this reply helpful? Yes No
MrsDunlap 25 on at

Like (0)

Report

Here is the whole formula: With({lclRecs:Filter(TimeTracker, Title=glbUser && StartsWith(ActivityDateTime, Text(Today(), "yyyymmdd")

Test(Today().docx

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
With({lclRecs:Filter(TimeTracker, Title=glbUser && StartsWith(ActivityDateTime, Text(Today(), "yyyymmdd")))})

missing closing parentheses brackets etc

Was this reply helpful? Yes No
MrsDunlap 25 on at

Like (0)

Report

Still not working.

Test(Today().docx

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report

None of your screenshots have the closing brackets or parentheses in them so it still looks like it isn't working (in the example you shared) because it is an incomplete formula.

We should also ask exactly what you are trying to accomplish. as in a With the {} is uaully onyl half of the formula as you can see here

If you are not using it in this way, there may be easier ways to do what you need to do

Was this reply helpful? Yes No
Verified answer

MrsDunlap 25 on at

Like (1)

Report

Thank you so much. Had I finished the video, the error corrected itself. Here was the whole formula:
With({lclRecs:Filter(TimeTracker, Title=glbUser && StartsWith(ActivityDateTime, Text(Today(), "yyymmdd")))},
{
LogOn: LookUp(lclRecs, ActivityType="Log On", ActivityDate),
LeaveOut: LookUp(lclRecs, ActivityType="Leave Out", ActivityDate),
LeaveIn: LookUp(lclRecs, ActivityType="Leave In", ActivityDate),
LogOff: LookUp(lclRecs, ActivityType="Log Off", ActivityDate)
}
)

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report

Huzzah!

Was this reply helpful? Yes No