How to get current datetime in function field in reports

[Shusovit Dutta]

I want to get the current datetime in the report function field, but it seems glidedatetime does not work here. Please suggest a way I can get the current datetime.

[AndersBGS]

Hi @Shusovit Dutta ,

This is not how you can utilize the function field. Function field take two constants from the table in scope and by those two fields you can do a datediff. You can't do a datediff with current timestamp.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[AN2023]

Hi AndersBGS,

How do you report on how many days a record has been open?

Thanks, Audrey

[AndersBGS]

Hi @AN2023 ,

This is the correct approach on how to utilize function fields.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[AN2023]

Hi @AndersBGS ,

That appears to work great between the open date and the closed date. 

What I'm looking for is to find the datediff between the open date and Today's date.

Do you have any tips on how to get that in a formula?

Thanks, Audrey