You’re offline. This is a read only version of the page.
674
Hi,
I would like to have a function field where I convert an existing datetimefield to an integer f.e. representing the old fashioned days since the beginning of the 20th century.
I can see I can use the datediff function in a function field type but not the datevalue function. So I see no way to actually enter a date like "01-01-1900" into the function.
Also if i would like to convert the date to text in a function type field I have no options. Text() only alows numbers in this context no dates.
Is de function field type still in it's child-shoes or am I missing things?
Hi @HansHeintz ,
Are you talking about a Formula type column in Dataverse? Since you posted this in the Power Apps community on the Building Power Apps forum, I assumed this was about Power Apps.
In case you are talking about Dataverse, then you are right: Dataverse formula columns are not in General Availability yet, but in preview so functionality is limited: Work with Dataverse formula columns - Power Apps | Microsoft Learn
Eventually these formula type columns are supposed to replace calculated columns, but those don't support what you are looking for either: Define calculated fields | Microsoft Learn
The workaround I've been exploring is to add a another column to the table:
Using a business rule this is automatically set to 1/1/1900 upon creation of a new row:
This column can now be used in the Formula column (or calculated column) to act as the reference:
What I can use is the Now() function but this seems a bit silly since what is now now will not be now when I look at the data and I guess the value for this field is hard coded into the table everytime a change to the record is made.
Sorry the Date function is not valid in the syntax for a formula field type.
Hi @HansHeintz ,
To get a fixed date, you can use the Date() function:
Share
Report
All responses (
Answers (
Date(1900,1,1)
You can then convert this to a text using the Text() function:
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
