Forum Discussion
Axit
6 years agoAdvocate II
Using date in a custom column
So this is probably simple, but I'm stuck here. This is what my dates look like: I'm trying to create a new custom colum that does discipline codes before a certain date to create a Gr...
- 6 years ago
Axit -
Showing the error would have helped us ๐
#date(1,1,2008) is incorrect. It should be
#date(year as number, month as number, day as number)Another issue is you are using #date when your values are of DateTime thereby needing #datetime as
#datetime(year as number, month as number, day as number, hour as number, minute as number, second as number) as any
ChrisMendoza
6 years agoResident Rockstar
Axit -
Showing the error would have helped us ๐
#date(1,1,2008) is incorrect. It should be
#date(year as number, month as number, day as number)
Another issue is you are using #date when your values are of DateTime thereby needing #datetime as
#datetime(year as number, month as number, day as number, hour as number, minute as number, second as number) as any