Unanswered

Formula Column Weekday function

(0) Share

Report

Posted on by Jaimesca

Hi Community,

I am creating a formula column (date only ), in a Dataverse table, to get a date but to remove the weekends, but when I try to use the function Weekday('Created On') it tells "Weekday cannot be performed on this input without a time zone conversion, which is not supported in formula columns." I have tried creating a new column just as date only to use that one instead of Created On but it shows the same error. Does someone know how to get this function working?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report

Hi @Jaimesca81 ,

It is not available cause 'Created on' can not be set to Time zone independant or data only. But you could add a new text type column and use flow to update this field. I've made a test for your reference:

Best Regards,

Bof

Was this reply helpful? Yes No
Jaimesca 11 on at

Like (0)

Report

thanks @v-bofeng-msft ,

I was looking to avoid extra columns but seems the way it works, thanks much

Cheers

Was this reply helpful? Yes No