Skip to main content

Search

Search

2 Dates; One current date and the other a year ahead.

Comments

2 comments

  • Avatar
    Peter Thane

    Depending on your source of the base date then one way to achieve this would be to make the 2nd field an Object Value field and link it to the text field that has the other date (as per the image below). Then adjust the Type of the field to Clock and that will allow you to use the Transforms>Offset option to offset the date by a year. 

     

     

    If you base date is fixed or comes from a database then you could just add the field on twice and then use the offset applied to that.

    You can use the Custom Data Format option to change the way the string looks but I dont think the '23 would be possible and so if you wanted this you need to add a second substring for just the year and add a <SPACE>' prefix to it like shown below

    0
  • Avatar
    Cassie Ward

    This is exactly what I needed! Thank you so much :) 

    0

Please sign in to leave a comment.