Need help creating a timestamp that doesn't change once entered like now() does

4

And once you want to reuse the timestamp data again, it is easily done since the data is already structured properly by adding the ToDate() function and if you want to substract from this day Today() you can write it as below

`today() - thisRow.Timestamp.ToDate()

image
image1756×560 44.7 KB

The data I often get in as text is structured in a EU format. If that is the case I have to bring it back to the ‘source format’ which is month,day, year (mm,dd,yyyy) and I use a formula like the one below:

image
image776×341 7.89 KB

Concatenate(thisRow.[Created at].Split("-").Nth(2),"/",thisRow.[Created at].Split("-").Nth(1),"/",thisRow.[Created at].Split("-").nth(3)).Todate()

The reordering of data takes place via the Nth() Via Split() I turn the text string into a list and each position in a list can be pointed to via Nth()

3 Likes