Announcements
Hi !
Source an Sharepoint list.
'gate_date' field type date /hungaryan format/
If(ThisItem.'gate_date'> DateValue(2021.01.01), DarkSeaGreen,White)
What am I writing wrong.. and why ?
Thx !
I dont know how is hungarian format but try this:
If(ThisItem.'gate_date'> DateValue("2021/01/01","hu-HU"), DarkSeaGreen,White)
I think that the format is corret but if that does not work try using Hungary format (I think it is hu-HU but not sure)
If you need additional help please tag me in your reply and please like my reply.If my reply provided you with a solution, pleased mark it as a solution ✔️!Best regards,Gonçalo NogueiraCheck my LinkedIn!My website!My blog!
it works, thx !!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 103
WarrenBelz 82 Most Valuable Professional
wolenberg_ 67 Super User 2026 Season 1