How to create a calculated field with a constant date value

Andy Swartz shared this question 20 months ago
Answered

I need to create a calculated field in my query that will serve as a temporary reference date against which other date values from the database will be compared. The reference date will not be pulled from the database. Instead, I want the query to prompt "What is the reference date?" The query will then show the variance of date values in my tables from the reference date.

How can I do this?

Replies (3)

photo
1

Hi Andy,

Thanks for reaching out with your question. I'll leave this open to Community comment and see if I can ask one of our consultants their thoughts on this.

Thanks,

Eric

photo
1

Still could use some help with this.

Thanks,

Andy

photo
1

Hi Andy,

I'd recommend reviewing our wiki for self help options, and feel welcome to reach out to an account manager for this type of content creation assistance.

Thanks,

Eric

Leave a Comment
 
Attach a file