Show Today and yesterday in calculated date field

[wattmhite]

I have a date field that is set by record created date, whenever I create a new record in this table it enters the current date.

This is a phone log field so there are literally hundreds of thousands of records.

I'm trying to create a calculation that displays the today, if the record created date is current date, and yesterday if it was yesterday and all other should be the date itself but when I create this calculation, it doesn't seem to update on a daily basis and just shows today even if the date was yesterday, unless I create a new record.

Any ideas on what I'm doing wrong here?

[comment]

14 minutes ago, wattmhite said:

it doesn't seem to update on a daily basis

Is it an unstored calculation field?

--
P.S. Your title says "calculated date field". IIUC, you want the field to display the text "Today" or "Yesterday" under some circumstances. If so, this needs to be a calculation field with the result type set to Text.

[Cable]

case(

datefield = get(currentdate);"Today";
datefield = get(currentdate)-1;"Yesterday";
datefield

)

 

Must be an unstored calculation and type = text as noted above.

Edited October 16, 2019 by Cable

[Matthew R White]

Cable, thank you!!! That worked perfectly!!

I have a super trick/hard question to go with this: Is there any way possible, to make sure this calculation field displays the date field in xx/xx/xx format? IE not the 4 digit year? 

[comment]

9 minutes ago, Matthew R White said:

make sure this calculation field displays the date field in xx/xx/xx format?

What exactly is " xx/xx/xx format"? It could be MM/DD/YY or DD/MM/YY or any other combination of the three.

 

[Cable]

10 minutes ago, Matthew R White said:

Cable, thank you!!! That worked perfectly!!

I have a super trick/hard question to go with this: Is there any way possible, to make sure this calculation field displays the date field in xx/xx/xx format? IE not the 4 digit year? 

Are you trying to create Y2K all over again????? lol

Substitute ( datefield; year(datefield); Right ( year(datefield); 2))

[Matthew R White]

Haha no I am not!!!!! 

Thank you!!

 

[bcooney]

Display:

[Cable]

On 10/25/2019 at 6:14 PM, bcooney said:

Display:

Sure, if it was a date field. But this is a text field so that won't work.