I have a GI which I would like to show a column with not only the date, but also show two columns with the Year and Month part of the date. I have tried using =CSTR(Year([ARTran.Date]), =CSTR(Month([ARTran.Date]), =Year([ARTran.Date]) (using the formula editor for the last one), but the column, sadly remains empty. I am not using it as a filter, just need the two added columns.
Parse ARTran.Date to show a column with just the date and month, not filtered
I just figured it out. Duh!. The ARTran.Date doesn’t have anything in it. By using the ARTran.TranDate I am able to do what needs to be done.
Userlevel 7
Thank you for sharing your solution with the community
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.