Create a field for status update date

benm_2000
benm_2000 Member
in Beast Mode

i need help creating a field for status update date and not update at. this is for insurance policy claims. im not sure what more information to provide .

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can join your original dataset to the new dataset based on your ID. Then use a formula tile to see where the status fields differ and then populate the updated date using CURRENT_TIMESTAMP() function.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • Sean_Tully
    Sean_Tully Contributor

    How is the dataset you're using structured?

    And can you clarify your first sentence? I'm not sure what "and not update at" means.

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can join your original dataset to the new dataset based on your ID. Then use a formula tile to see where the status fields differ and then populate the updated date using CURRENT_TIMESTAMP() function.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories