DateTimeAdd

[zraposoaandm]

 

 DateTime_Out in the second picture is in datetime format. When I use the function DateTimeAdd and increase DateTime_Out by 1 day, how do I get the function to spit out just yyyy-mm-dd instead of yyyy-mm-dd hh:mm:ss (00:00:00)? I don't want the hh:mm:ss

[ScottLewis · Accepted solution]

Change the Data type from DateTime to Date. 

Alternately, you could wrap the datetime add in a datetime format like: 

DateTimeFormat(DateTimeAdd([DateTime_Out],1,"day"),"%Y-%m-%d")

but changing the type should work just fine.

[zraposoaandm]

Scott, thank you so much! ran into this problem a couple times so far so it's nice to understand what was going wrong.