I'm creating a date with a formula filed by combining two separate fields.
ex. Month = 01/01/
ex. Year = 2019
The formula field reads "01/01/2019"

The problem is I can't filter the formula as a date.
Is there a ways to convert a formula field to be reads as a Date/Time field?
Or is there a way to copy information into a Date/Time field?

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## Matthew

I'm creating a date with a formula filed by combining two separate fields.

ex. Month = 01/01/

ex. Year = 2019

The formula field reads "01/01/2019"

The problem is I can't filter the formula as a date.

Is there a ways to convert a formula field to be reads as a Date/Time field?

Or is there a way to copy information into a Date/Time field?

Any help would be much appreciated.

## Link to comment

## Share on other sites

## 1 answer to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Note:Your post will require moderator approval before it will be visible.