-
1. Re: Change date to today
Kaushik Dutta Apr 3, 2018 1:53 AM (in response to Tamas Tyukos)Hi Tyukos
Try this code:-
IF YEAR([Date])=Year(today())
THEN TODAY()
ELSE [Date]
END
Attached is the solution as well
-
Community.twbx 9.3 KB
-
-
2. Re: Change date to today
Tamas Tyukos Apr 3, 2018 2:41 AM (in response to Kaushik Dutta)I understand your solution, but I think I failed to write down my problem properly. In reality there are much more date rows for one ID, I just gave a sample what it looks like.
What calculation would be good for me is the one, which only changes the latest date to today.
1 2018.03.05 2018.04.03 1 2018.02.15 2018.02.15 1 2018.01.01 2018.01.01 -
3. Re: Change date to today
meenu choudhary Apr 3, 2018 2:14 AM (in response to Tamas Tyukos)Hi ,
Use below calculation :
IF YEAR([Date])=YEAR(TODAY()) then TODAY() else [Date] END
-
4. Re: Change date to today
Oindrila B Apr 3, 2018 2:45 AM (in response to Tamas Tyukos)2 of 2 people found this helpfulHi Tamas,
Try this calculation - IIF({ FIXED [ID]: MAX(DATE([Date]))}=DATE([Date]),TODAY(),DATE([Date]))
Drag this field into your view besides ID,DATE
Remove the DATE() function if your date field is in DATE datatype already
Let me know if this works
Thanks,
Oin
-
-
6. Re: Change date to today
Tamas Tyukos Apr 4, 2018 12:55 AM (in response to Oindrila B)This is perfect, thank you!